mysql修改字符集

show variables like 'collation_%';

show variables like 'character_set_%';

set character_set_client=utf8;客户端编码方式

set character_set_connection= utf8;建立连接使用的编码

set character_set_database= utf8;数据库的编码

set character_set_results= utf8;结果集的编码

set character_set_server= utf8;数据库服务器的编码


/etc/mysql/my.cnf
[mysqld]
default-character-set=utf8
collation-server=utf8_general_ci
default-storage-engine=INNODB
　
[mysql]
default-character-set=utf8