C # Connection Mysql Chinese garbled problem solving method

Method One
Open the My.ini of the MySQL tutorial installation directory, adding default-character-set= in [client] and [mysqld] respectively gb2312
When you create a new table, select character set and collation as gb2312 and Gb2312_chinese_ci respectively.

Method Two

Use the mysql_query (MySQL *mysql, const char *STMT_STR) to set the character encoding for each query statement:

mysql_query (&mysql, "Set names GBK");

Ensure that each query is based on the GBK encoding of the query, where the following conditions, such as: ' table.column1 ' = The following string is GBK encoding;

Method Three

Mysqlcommand SetFormat = new Mysqlcommand ("Set names gb2312", m_connection);
Setformat.executenonquery ();
Setformat.dispose ();