show variables like 'character\_set\_%'
18. 修改编码
create database 库名 character set utf-8; //创建数据库时设置编码
alert database 库名 character set utf8;
19.编码设置
set character_set_client=utf8;
set character_set_connection=utf8;
set character_set_database=utf8;
set character_set_filesystem=utf8;
set character_set_results=utf8;
set character_set_server=utf8;
set character_set_system=utf8;
20.查看字符集设置
show create table 表名 或 show full columns from 表名
21.当前联接系统参数
show variables like 'char%'