windows的默认编码为gbk，如果你在win下运行SQL文件时插入中文序列发现老是出现ERROR 1366 (HY000):Incorrect string value错误，并且更改编码方式为utf-8后仍然不能解决问题的话，尝试用Navicat来运行SQL吧。
相关文章
- MySQL 导入csv文件ERROR 1366 (HY000): Incorrect integer value FEFF1 for column id at row 1 可能的解决方法
- ERROR 1366 (HY000): Incorrect string value: '\xC1\xF5\xB1\xB8' for column 'name' at row 1
- 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
- MySQL表中存Emoji报错Error 1366: Incorrect string value的解决方法
- Slave SQL: Error 'Incorrect string value ... Error_code: 1366
- MySQL Error Code: 1366. Incorrect string value解决 & 存储过程模糊查询LIKE语句