View the default encoding of the MySQL database

View the default encoding of the MySQL database. Use the status command to display the relational information of the database, for example: mysqlstatus; ---- mysqlVer14.12Distrib5.0.77, forWin32 (ia32) Connectionid: 1072 Currentdatabase: Currentuser: test@119.119.247.6SSL: NotinuseUsin

View the default encoding of the MySQL database. Use the status command to display the related information of the database. for example: 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

View the default encoding of the MySQL database

Use the status command to display the relational information of the database, for example:

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

You can also use the following command:

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)