Yan Myo Naing
Yan Myo Naing

Reputation: 1

VB.NET, MySQL and Unicode

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

Answers (3)

Ahmed Azim
Ahmed Azim

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

ioannis
ioannis

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

Vasilis
Vasilis

Reputation: 11

CharacterSet=UTF8; worked for me. (Character Set=UTF8; not worked) driver MySQL Connector NET 6.5.4

Upvotes: 1

Related Questions