mysql插入数据报 （Incorrect string value: ‘\xB6\xFE’ for column ‘name’ at row 1）
- 2020 年 10 月 8 日
- 筆記
这是我的表结构
mysql> describe students; +--------+---------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------+---------------------+------+-----+---------+----------------+ | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | name | varchar(20) | NO | | NULL | | | age | tinyint(3) unsigned | YES | | 0 | | | height | decimal(5,2) | YES | | NULL | | | gender | enum(' | YES | | NULL | | +--------+---------------------+------+-----+---------+----------------+ 5 rows in set, 2 warnings (0.01 sec) mysql>
插入数据的时候报错
mysql> insert into students values('5','平二','18','160',2); ERROR 1366 (HY000): Incorrect string value: '\xB6\xFE' for column 'name' at row 1 mysql>
这是编码问题导致的，解决
mysql> set names gbk; Query OK, 0 rows affected (0.00 sec) mysql> insert into students values('5','平二','18','160',2); Query OK, 1 row affected (0.00 sec)
