Error code:1366-incorrect String Value: ' * * * ' for * * * Row 1

Today to handle a problem with the report, execute MySQL update script times wrong:

Error code:1366-incorrect String value: ' \XB3\XAC\XCA\XD0\XBB\XDD ' for column ' Changecdtionname ' at row 1

Repeated analysis, looking for a similar error on the network solution, can not find a good method.

Know this is a coding problem, reported error: 1, check the MySQL database encoding is utf-8

2, the code of the CentOS system is viewed: LANG=ZH_CN. UTF-8

This is strange, all is Utf-8, how to update the script also reported coding problem?

Suddenly think, look at the script file encoding format: So, the script file format is: ANSI ... Think, should be the staff to perform the update, copy and paste, the original Utf-8 script changed to ANSI ...

However, summed up, the problem of reporting this error is the character encoding problem: the database, the system and the file itself to encode the same ....

This article is from the "Guangzhou Linux operation and Maintenance" blog, please be sure to keep this source http://milenovo.blog.51cto.com/10554394/1697120

Error code:1366-incorrect String Value: ' * * * ' for * * * Row 1