mysql> INSERT INTO work_info VALUES(1,'张三','M',18,'北京市海淀区','1234567');
报错:
ERROR 1366 (HY000): Incorrect string value: '\xE5\xBC\xA0\xE4\xB8\x89' for column 'name' at row 1
错误原因:
是字段'name'的字符集(character set)的问题。
先看看当前的字符集:
mysql> SHOW VARIABLES LIKE 'character%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | latin1 |
| character