MySql Connector/Net Mysql like search for Chinese (c # And asp.net connect to mysql ),

MySql Connector/Net Mysql like search for Chinese (c # And asp.net connect to mysql ),
Connector/Net 6.9.8

Select. net/mono without installation.

Copy MySql. Data. dll of the corresponding version to the bin directory.

Http://dev.mysql.com/downloads/connector/net/

 

However, when using the like Statement of mysql to retrieve Chinese characters, data is always not retrieved. It turns out that this is a character encoding.

 

using MySql.Data.MySqlClient;

String query = @ "(SELECT * from TB where title LIKE '% %')"; MySqlConnection myConnection = new MySqlConnection ("server = 192.168.168.2; port = 3306; user id = uid; password = pwd; database = dba;Charset = utf8"); MySqlCommand myCommand = new MySqlCommand (query, myConnection); myConnection. open (); MySqlDataReader myDataReader = myCommand. executeReader (); while (myDataReader. read () = true) {string name = myDataReader ["name"]. toString (),} myDataReader. close (); myConnection. close ();

Note that it cannot be written as UTF-8

 

If the configuration file is used:

<add name="MySqlProductDB" connectionString="Server=192.168.100.104;Database=ProductDB;Uid=root;Pwd=JUSTZEE;charset=utf8" providerName="MySql.Data.MySQLCLIENT" />