Reputation: 1
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.
Upvotes: 0
Views: 7336
Reputation: 1
try this method.. it work for me
Public ConnString As String = "Server=localhost;
Database=shiftd;
Uid=root;
Pwd=;
Character Set=utf8;"
Upvotes: 0
Reputation: 337
You simply add
Character Set=utf8;
inside your connection string. Example:
conn.ConnectionString = "Server=localhost; Database=db;Uid=user;Pwd=pwd;Character Set=utf8;"
Upvotes: 4
Reputation: 11
CharacterSet=UTF8;
worked for me. (Character Set=UTF8;
not worked) driver MySQL Connector NET 6.5.4
Upvotes: 1