对于表格
查看表字符编码:
show create table user \G;
创建时设置默认字符编码:
create table user(name varchar(25)) default charset=utf8;
对于数据库
查看数据库字符编码:
show variables like '%char%';
修改:
set character_set_server=utf8;
set character_set_database=utf8;
对于mysql配置文件
[mysqld] character-set-server=utf8
[client] default-character-set=utf8
[mysql] default-character-set=utf8