今天使用navicat向MySQL中插入中文时，报错：
1366 - Incorrect string value:...
在我自己数据库设计之初，没有设计好字符编码格式的问题。
使用如下语句解决：
alter table tableName convert to charset utf8;
相关文章
- MySQL 执行插入操作时报1366 - Incorrect string value: '\xE4\xB8\xAD\xE6\x96\x87' for column 'name' at row 1
- MySQL 执行插入报错 - Incorrect string value: '\xE4\xB8\xAD\xE6\x96\x87' for column 'name' at row 1
- ERROR 1366 (HY000): Incorrect string value: '\xC1\xF5\xB1\xB8' for column 'name' at row 1
- 解决mysql插入数据时出现Incorrect string value: '\xF0\x9F...' for column 'name' at row 1的异常
- 1366 - Incorrect string value:'\xE5\xBC\xA0\xE4\xB8\x89' for column 'name' a 错误修改
- ERROR 1366 (HY000): Incorrect string value:’XXX’ for column 'XXX at row 1解决
- ERROR 1366 (HY000): Incorrect string value: '\xC6\xF4\xD3\xC3' for column 'name' at row 1
- ERROR 1366 (HY000): Incorrect string value: '\xD6\xD0\xCE\xC4' for column XXX at row 1
- ERROR 1366 (HY000): Incorrect string value: '\xE5\xB8\x82' for column 'address' at row 1
- ERROR 1366 (HY000): Incorrect string value: '\xD5\xC5\xC8\xFD' for column 'name' at row 1