ERROR 1366 (HY000): Incorrect string value: '\xA6' for column 'jy_message' at row 1
这个问题是字符集导致的
查看数据库字符集
mysql> show variables like 'character%';
+--------------------------+-----------------------------------------+
| Variable_name | Value |
+--------------------------+-----------------------------------------+
| character_set_client | gbk |
| character_set_connection | gbk |
| character_set_database | gbk |
| character_set_filesystem | binary |
| character_set_results | gbk |
| character_set_server | gbk |
| character_set_system | utf8 |
| character_sets_dir | /export/servers/mysql56/share/charsets/ |
+--------------------------+-----------------------------------------+
8 rows in set (0.00 sec)
由于数据库字符集为GBK,那么如果插入报错,说明插入的数据为UTF-8的
解决思路:
1、将表字符集更改为UTF-8
ALTER TABLE OLD_TABLE CONVERT TO CHARACTER SET charset_name [COLLATE collation_name]直接对整个表操作。
2、利用navicate导入数据,
编码设置为UTF-8即可