Re: How to show right Chinese in "Latin1" by VS.NET?

[Reggie Burnett]

Cai

WHat version of MySQL are you working with? If you are using 4.1 or higher, you will need to convert the strings to a proper chinese character set in your selects and then use the proper character set on your connection. You would connect with something like the following:

string connStr = "server=xxx;uid=xxx;pwd=xxx;character set=utf8";
MySqlConnection c = new MySqlConnection(connStr);

then on your selects, do the following:

select convert(field1 using utf8), convert(field2 using utf8), ...

a pain I know. the real solution is to set the proper character set on your tables.