日期:2014-05-16  浏览次数:20812 次

设置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)