MySQL Setup encoding

MySQL Setup encoding version mysql-5.6.21-winx64

MySQL default encoding:

mysql> show variables like  ' character% '; +--------------------------+------------------- --------------------------+| 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       | d:\soft\mysql-5.6.21-winx64\share\ charsets\ |+--------------------------+---------------------------------------------+8 rows in  set  (0.00 sec) mysql>

MySQL Setup encoding

SET character_set_client = UTF8;

SET character_set_connection = UTF8;

SET character_set_database = UTF8;

SET character_set_results = UTF8;

SET character_set_server = UTF8;

mysql> SET character_set_client = UTF8; Query OK, 0 rows Affected (0.00 sec) mysql> SET character_set_connection = UTF8; Query OK, 0 rows Affected (0.00 sec) mysql> SET character_set_database = UTF8; Query OK, 0 rows Affected (0.00 sec) mysql> SET character_set_results = UTF8; Query OK, 0 rows Affected (0.00 sec) mysql> SET character_set_server = UTF8; Query OK, 0 rows Affected (0.00 sec) mysql>

This method is only valid in the current state and is invalidated when the database service is restarted. so if you want to not garbled only modify the My.ini file.

Modify the My.ini file setting encoding

[Client]default-character-set=utf8[mysql]default-character-set=utf8[mysqld]character-set-server=utf8

Under the corresponding label, add the following configuration:

To restart the MySQL server:

C:\users\lenovo>net Stop Mysqlmysql service is stopping. The MySQL service has stopped successfully. C:\users\lenovo>net Start Mysqlmysql service is starting. The MySQL service has started successfully. C:\users\lenovo>

===========end===========

MySQL Setup encoding