View the default encoding of the MySQL database _ MySQL

View the default MySQL database code bitsCN.com

View the default encoding of the MySQL database

1. 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)Connection id:          1072Current database:Current user:           test@119.119.247.6SSL:                    Not in useUsing delimiter:        ;Server version:         5.0.67-log MySQL Community Server (GPL)Protocol version:       10Connection:             www.chinajvm.com via TCP/IPServer characterset:    gbkDb     characterset:    gbkClient characterset:    latin1Conn. characterset:    latin1TCP port:               3306Uptime:                 15 days 2 hours 21 min 37 sec

2. 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)

BitsCN.com