Adding chinese characters using mysql .net connector

Posted Tuesday, October 25, 2005 2:08 AM by Shunjie
I got this problem when adding chinese characters to mysql database using mysql .net connector. After changing the database encoding to utf-8 and the page encoding to utf-8, i still get ??? when inserting information into the database. Finally, the problem is solved by insert 'charset=utf8' to the connection string, so it looks something like this:

Database=<dbname>;Data Source=<source>;User Id=<userid>;Password=<password>;charset=utf8

=)
Filed under: ,