查看MySQL数据库的默认编码

查看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                                       |
|character_set_system    |utf8                                      |
|character_sets_dir      | /mysql/mastermysql50/share/mysql/charsets/ |
+————————–+——————————————–+
8 rows in set (0.03 sec)