C # mysql Insert data, Chinese garbled solution

When you operate MySQL in C #, the data inserted in Chinese is garbled, only the question mark is displayed, and the database itself uses the Utf-8 character

There are two ways to solve this problem:

One is set in front of the execution statement, such as:

1 mysqlcommand mcommand = new mysqlcommand ("set names gb2312", m_ Connection);

The other is directly added to the connection string, such as:

1 <add name="connection" connectionstring="server=127.0.0.1; Uid=root; Password=root; Persist Security info=true;database=test; Charset=utf8; " providername="MySql "/>  

C # mysql Insert data, Chinese garbled solution