ERROR 1366 (HY000): Incorrect string value: ' XXX ' for column ' xxx at ro

ERROR 1366 (HY000): Incorrect string value: ' XXX ' for column ' xxx at row 1 resolves

Environment

MySQL Server 5.5.27 + command line tools

Problem

The following error occurred in the insert Chinese character data:

ERROR 1366 (HY000): Incorrect stringvalue: ' \xbd\xf1\xcc\xec\xcc\xec ... ' for CO

Lumn ' Messagecontent ' at row 1

Environmental reproduction

--Here is the INSERT statement:  
INSERT INTO sms_inbox values (' 123456 ', ' 123456 ', ' CD ', Sysdate (), ' Today  
's Day is very good, 1, sysdate (), ' 123456 ');  
       
--Error:  
ERROR 1366 (HY000): Incorrect stringvalue: ' \xbd\xf1\xcc\xec\xcc\xec ... ' for Co lumn ' 
messagecontent ' at row 1  
       
-- Solution: Set the encoding  
names GBK;  
       
Query OK, 0 rows affected (0.02 sec)

Summarize

When garbled, is the problem of encoding, you can try to set the database encoding (set NAMs GBK).