查看当前mysql字符集的参数

用mysql进入client console,
输入show variables like 'character\_set\_%';
显示如下结果
+--------------------------+--------+
| Variable_name | Value |
+--------------------------+--------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | utf8 |
| character_set_system | utf8 |
+--------------------------+--------+

 

 

也可以使用mysql> status