MySQL插入语句执行出错ERROR1366，不正确的字符串值

谁践踏了优雅 2023-06-02 12:56 9阅读 0赞

ERROR 1366 (HY000): Incorrect string value: '\xC1\xF5\xB5\xC2\xBB\xAA' for column 'sname' at row 1

笔者执行了这样一条简单的语句后出现的上面的错误

mysql> insert into student values('刘德华',100124,1,null,'声乐192班');

这个表设计是这样的。

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mzc5MjQwMQ_size_16_color_FFFFFF_t_70][]

我查询了一下结构，看到了表的字符集是Latin1

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mzc5MjQwMQ_size_16_color_FFFFFF_t_70 1][]

所以改动一下字符集

mysql> alter table student character set utf-8;

重新执行插入语句，发现还是原来的错误，就再查询一次表结构，发现表的更改了，字段的又来了两个

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mzc5MjQwMQ_size_16_color_FFFFFF_t_70 2][]

我一一把它们改了

mysql> alter table student modify sname  varchar(20)  character set gbk;

mysql> alter table student modify class varchar(20)  character set gbk;

继续执行插入语句，插入成功，再查看表数据，确认无误。

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mzc5MjQwMQ_size_16_color_FFFFFF_t_70 3][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mzc5MjQwMQ_size_16_color_FFFFFF_t_70]: /images/20230601/9f4c6d478f4443ab876bbb53ee07a74f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mzc5MjQwMQ_size_16_color_FFFFFF_t_70 1]: /images/20230601/a395b2419f3844cc8f532fa038118736.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mzc5MjQwMQ_size_16_color_FFFFFF_t_70 2]: /images/20230601/a578f250ce8346ffa05d1f920ecf9a83.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mzc5MjQwMQ_size_16_color_FFFFFF_t_70 3]: /images/20230601/6b3bad95791349a5a3472b2222abee67.png