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
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