linux 下设置MySQL字符集

• 修改配置文件

 

sudo gedit /etc/mysql/mysql.conf.d/mysqld.cnf 

 

[mysqld]
#
# * Basic Settings
#
character-set-server = utf8

• 修改数据库字符集

alter database db_name default character set character_name;

• 修改表字符集

alter table table_name default character set character_name;

• 修改字段字符集

alter table table_name change c_name c_name character set character_name;

• 查询字符集

show variables like 'character%';

 

• 查看数据库编码

show create database db_name;

• 查看表编码

show create table table_name;