查看mysql数据库的默认编码使用status命令能够显示数据库的相关系信息,示例如下：
mysql> status;
————–
mysql ver 14.12 distrib 5.0.77, for win32 (ia32)
connectionid: 1072
current database:
currentuser: test@119.119.247.6
ssl: not in use
usingdelimiter: ;
serverversion: 5.0.67-log mysql community server (gpl)
protocolversion: 10
connection: www.chinajvm.com via tcp/ip
servercharacterset: gbk
db characterset: gbk
clientcharacterset: latin1
conn.characterset: latin1
tcpport: 3306
uptime: 15 days 2 hours 21 min 37 sec
也可以使用如下命令：
mysql> show variables like’char%’;
+————————–+——————————————–+
|variable_name |value |
+————————–+——————————————–+
|character_set_client |latin1 |
| character_set_connection |latin1 |
| character_set_database |gbk |
| character_set_filesystem |binary |
|character_set_results |latin1 |
|character_set_server |gbk