MySQL error 1366 when inserting Chinese (HY000): Incorrect string value: ' \xc0\xee\xcb\xc4 ' for column ' Usern ame ' at row 1

1 Environment: MySQL Server 6.0 command-line tools

2 PROBLEM: Insert Chinese character data The following error occurred:

ERROR 1366 (HY000): Incorrect string value: ' \xc0\xee\xcb\xc4 ' for column ' Usern ame ' at row 1

3 environment at that time:

mysql> INSERT into user (ID, username, birthday, sex, address) VALUES ('2','John doe' , '1980  A- to' ,  'Male' , 'Beijing');ERROR1366(HY000): IncorrectstringValue'\xc0\xee\xcb\xc4'  forColumn'UsernAme'At Row 1Mysql>Select* fromuser; EmptySet(0.00sec) MySQL>Setnames GBK; Query OK,0Rows Affected (0.00sec) MySQL> INSERT into User (ID, username, birthday, sex, address) VALUES ('2','John doe' , '1980  A- to' ,  'Male' , 'Beijing');Query OK,1Row affected (0.10sec) MySQL>Select* fromuser;+----+----------+------------+------+---------+| ID | Username | Birthday | sex | Address |+----+----------+------------+------+---------+|2| John Doe |1980  A- to| Male | BEIJING |+----+----------+------------+------+---------+1Rowinch Set(0.00Sec

4 Summary

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

MySQL error 1366 when inserting Chinese (HY000): Incorrect string value: ' \xc0\xee\xcb\xc4 ' for column ' Usern ame ' at row 1