查看所有应用的字符集
mysql> show variables like 'character%';
Variable_name | Value |
---|---|
character_set_client | gbk |
character_set_connection | gbk |
character_set_database | latin1 |
character_set_filesystem | binary (文件系统字符集 ) |
character_set_results | gbk |
character_set_server | latin1 |
character_set_system | utf8 |
character_sets_dir | C:\Program Files\MySQL\MySQL Server 5.6\share\charsets\ (目录字符集) |
指定字符集登录: