Re: .NET, MySQL and Unicode Problem

[Richard Creer]

It can be made to work but it takes some persistance!

You need to set up your tables for Unicode specifying utf8 in all the appropriate places.

MySQL Connector .net is, at the moment, your only option.

Code like this works for me, the final piece in the puzzle being charset='utf8' in the connection string -

Dim conn As New MySqlConnection("Server=localhost;Port=3306;Database=mydb;Uid=myuser;Pwd=mypswd;charset='utf8';")
conn.Open()

Dim cmd As New MySqlCommand()
cmd.Connection = conn
cmd.CommandType = CommandType.Text

cmd.CommandText = "SET NAMES utf8;"
cmd.ExecuteNonQuery()

cmd.CommandText = "INSERT INTO `tpmvalue` SET" & _
" `Record ID` = " & CStr(myID) & _
",`Value 1` = " & UnicodeField.Text
cmd.ExecuteNonQuery()

conn.Close()

You also need a recent verion of MySQL Query Browser.

HTH