显示与设置MSQL字符集 博客分类： mysql MySQL

mysql> show variables like 'character\_set\_%';
+--------------------------+-------+
| Variable_name            | Value |
+--------------------------+-------+
| character_set_client     | gbk   |
| character_set_connection | gbk   |
| character_set_database   | gbk   |
| character_set_results    | gbk   |
| character_set_server     | gbk   |
| character_set_system     | utf8  |
+--------------------------+-------+
6 rows in set (0.00 sec)

mysql>

设置字符集
mysql> set character_set_server =gbk;
Query OK, 0 rows affected (0.00 sec)