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)
+--------------------------+-------+
| 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)