1.列出MYSQL支持的所有字符集：
SHOW CHARACTER SET;
2.當(dāng)前MYSQL服務(wù)器字符集設(shè)置
SHOW VARIABLES LIKE 'character_set_%';
3.當(dāng)前MYSQL服務(wù)器字符集校驗設(shè)置
SHOW VARIABLES LIKE 'collation_%';
4.顯示某[數(shù)據(jù)庫]字符集設(shè)置
show create database 數(shù)據(jù)庫名;
5.顯示某數(shù)據(jù)表字符集設(shè)置
show create table 表名;
6.修改數(shù)據(jù)庫字符集
alter database 數(shù)據(jù)庫名default character set 'utf8';
7.修改數(shù)據(jù)表字符集
alter table 表名default character set 'utf8';
8.建庫時指定字符集
create database 數(shù)據(jù)庫名character set gbk collate gbk_chinese_ci;
