本文内容:本文介绍了如何在控制台下通过命令检查mysql数据库的编码。
1.首先连接到数据库。
在cmd下输入。
& gtMysql -h数据库地址-u用户名-p密码
2.连接到数据库后。
使用status命令查看数据库的编码方法:
mysql> status; -------------- C:\Program Files\MySQL\MySQL Server 5.6\bin\mysql.exe Ver 14.14 Distrib 5.6.21, for Win32 (x86) Connection id: 1320 Current database: Current user: rdps@10.118.44.29 SSL: Not in use Using delimiter: ; Server version: 5.5.28 MySQL Community Server (GPL) Protocol version: 10 Connection: 10.118.46.4 via TCP/IP Server characterset: latin1 Db characterset: latin1 Client characterset: gbk Conn. characterset: gbk TCP port: 3306 Uptime: 2 days 1 hour 28 min 49 sec Threads: 10 Questions: 680380 Slow queries: 0 Opens: 167265 Flush tables: 2 Open tables: 4 Queries per second avg: 3.819 --------------如果要查看某个数据库的编码方式,必须先用use database name切换数据库。如果不知道哪些数据库可用,可以使用show databases
或者使用
<span style="font-size:14px;">mysql> show variables like 'char%'; +--------------------------+---------------------------------------------------- ---+ | Variable_name | Value | +--------------------------+---------------------------------------------------- ---+ | character_set_client | gbk | | character_set_connection | gbk | | character_set_database | latin1 | | character_set_filesystem | binary | | character_set_results | gbk | | character_set_server | latin1 | | character_set_system | utf8 | | character_sets_dir | /usr/local/mysql-5.5.28-linux2.6-i686/share/charset s/ | +--------------------------+---------------------------------------------------- ---+ 8 rows in set (0.00 sec)</span>更多相关教程,请访问MySQL视频教程