VB.NET, MySQL and Unicode

Question

How to input the textbox's unicode string to MySQL database. I changed utf8 charset the MySQL Database. I'm using VB.NET 2005 and MySQL Database for Window application. Please Help me.

Answer 1

You simply add

Character Set=UTF8;

inside your connection string. Example:

conn.ConnectionString = "Server=localhost; Database=db;Uid=user;Pwd=pwd;Character Set=UTF8;"