Rumah >pangkalan data >tutorial mysql >查看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 Usin
查看MySQL数据库的默认编码使用status命令能够显示数据库的相关系信息,示例如下:
mysql> status;
————–
mysql Ver 14.12 Distrib 5.0.77, for Win32 (ia32)
Connection
id:
Current database:
Current
user:
SSL:
Using
delimiter:
Server
version:
Protocol
version:
Connection:
Server
characterset:
Db
Client
characterset:
Conn.
characterset:
TCP
port:
Uptime:
也可以使用如下命令:
mysql> show variables like’char%’;
+————————–+——————————————–+
|
Variable_name
+————————–+——————————————–+
|
character_set_client
| character_set_connection |
latin1
|
| character_set_filesystem |
binary
|
character_set_results
|
character_set_server