MySQL Insert Chinese data error

The following error occurs when inserting Chinese in the operations database:

ERROR 1366 (HY000): Incorrect string value: ' \xc4\xe3\xba\xc3 ' for column ' username ' at row 1

Solution:

View the encoding settings for the current database in cmd: Server, Db, Client, Conn the respective encoding is set as follows

　　　　

　　If the client and the Conn code is not the platform code will appear in Chinese garbled situation received an error. Modify the my.ini file under the MySQL installation file .

　　

Note: In the 5.1 version of MySQL [MySQL] and [mysqld] are written Default-character-set=utf8

After the 5.5 version of MySQL these files are automatically configured under [MySQL] under the Default-character-set=utf8 under [mysqld] is Character-set-server=utf8

MySQL Insert Chinese data error