Problem: the form application developed by VS2005, the database is MySql.net; Queries statements with Chinese characters, no results are returned, and no error is reported !!!
MySql character encoding problem !!!
Solution:
1. Use MySQLDriverCS
After conn. open ();
Run the following command first:
MySQLCommand cmd = new MySQLCommand ("set charset gb2312", conn );
// Or MySQLCommand cmd = new MySQLCommand ("set charset gbk", conn); or yes. I have tried it all.
Cmd. ExecuteNonQuery ();
Cmd. Dispose ();
Execute other statements.
2. Use MySQL Connector/Net
Add charset = gb2312 after the connection string;
String connctionstr = "server = 192.168.1.121; user id = shide; password = shide; persist security info = True; database = shidevideo; port = 3307; charset = gb2312 ";
MySqlConnection con = new MySqlConnection (connctionstr );
MySqlDataAdapter dap = new MySqlDataAdapter (msg, con );
DataSet ds2 = new DataSet ();
Dap. Fill (ds2 );