[Err] 1366 - Incorrect string value: '\xE6\x95\xB0\xE6\x8D\xAE...' for column 'name' at row 1

drop table if exists courses;

create table courses (

courseNo int(10) unsigned primary key auto_increment,

name varchar(10)

);

insert into courses values

('1', '数据库'),

('2', 'qtp'),

('3', 'linux'),

('4', '系统测试'),

('5', '单元测试'),

('6', '测试过程');

插入语句报错：

[Err] 1366 - Incorrect string value: '\xE6\x95\xB0\xE6\x8D\xAE...' for column 'name' at row 1

 

 

设计表，将表的字符集改为utf8即可。