show create table t_student; 看一下这张表的字符集,建议改成 utf8 ;
排序规则呢,应该选哪个鸭,
utf8_bin
错惹。。 1025-Error on rename of…(error:150)
create table test(name varchar(10)) default character set latin1;insert into test values('信息技术');-- 只修改表的,列还是原来的 alter table test default character set utf8;-- 都修改了 alter table test convert to character set utf8;insert into test values('信息信息');select * from test;drop table test;
utf8_bin
1025-Error on rename of…(error:150)
alter table test default character set utf8;-- 都修改了
alter table test convert to character set utf8;insert into test values('信息信息');select * from test;drop table test;