4 总结
当出现乱码，就是编码的问题，可以尝试设置数据库的编码(set nams gbk)。
mysql 插入中文时出现ERROR 1366 (HY000): Incorrect string value: '\xC0\xEE\xCB\xC4' for column 'usern ame' at row 1
标签：
mysql 插入中文时出现ERROR 1366 (HY000): Incorrect string value: '\xC0\xEE\xCB\xC4' for column 'usern ame' at row 1
2‘ , ‘
李四‘ , ‘1980 12-31‘ , ‘male‘ , ‘beijing‘);
ERROR 1366 (HY000): Incorrect string value: ‘\xC0\xEE\xCB\xC4‘ for column ‘usern
ame‘ at row 1
mysql> select * from user;
Empty set (0.00 sec)
mysql> set names gbk;
Query OK, 0 rows affected (0.00 sec)
mysql> insert into user(id , username , birthday, sex, address) values(‘2‘ , ‘
李四‘ , ‘1980 12-31‘ , ‘male‘ , ‘beijing‘);
Query OK, 1 row affected (0.10 sec)
mysql> select * from user;
+----+----------+------------+------+---------+
| id | username | birthday | sex | address |
+----+----------+------------+------+---------+
| 2 | 李四 | 1980 12-31 | male | beijing |
+----+----------+------------+------+---------+
1 row in set (0.00 sec)