日期:2014-05-16 浏览次数:20997 次
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)