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;