mysql> insert into class values(1,"一班");
ERROR 1366 (HY000): Incorrect string value: '\xD2\xBB\xB0\xE0' for column 'name' at row 1
建表的时候设置字符编码
mysql> create table user6(
-> id int,
-> name varchar(20)
-> )default charset=utf8;
mysql> insert into class values(1,"一班");
ERROR 1366 (HY000): Incorrect string value: '\xD2\xBB\xB0\xE0' for column 'name' at row 1
建表的时候设置字符编码
mysql> create table user6(
-> id int,
-> name varchar(20)
-> )default charset=utf8;