Two ways to modify the Mysql default character set are detailed parsing _mysql

(1) The simplest method of modification is to modify the character set key values in the MySQL My.ini file ,
such as Default-character-set = UTF8
Character_set_server = UTF8

After the modification, restart the MySQL services, service MySQL restart
Use mysql> show VARIABLES like ' character% '; view, find the database code has been changed to UTF8

Copy Code code as follows:

+--------------------------+---------------------------------+
| variable_name | Value |
+--------------------------+---------------------------------+
| character_set_client | UTF8 |
| character_set_connection | UTF8 |
| Character_set_database | UTF8 |
| Character_set_filesystem | binary |
| Character_set_results | UTF8 |
| Character_set_server | UTF8 |
| Character_set_system | UTF8 |
| Character_sets_dir | D: "mysql-5.0.37" Share "charsets" |
+--------------------------+---------------------------------+

(2) There is also a way to modify the MySQL default character set, is the use of MySQL command

Copy Code code as follows:

mysql> SET character_set_client = UTF8;
mysql> SET character_set_connection = UTF8;
mysql> SET character_set_database = UTF8;
mysql> SET character_set_results = UTF8;
mysql> SET character_set_server = UTF8;
mysql> SET collation_connection = UTF8;
mysql> SET collation_database = UTF8;
mysql> SET collation_server = UTF8;

In general, even if the MySQL default set table is UTF8 and send a query via UTF-8 encoding, you will find that the database is still garbled. The problem is on the connection connection layer. The workaround is to execute the following sentence before sending the query:

Copy Code code as follows:

SET NAMES ' UTF8 ';

It corresponds to the following three-sentence instruction:

Copy Code code as follows:

SET character_set_client = UTF8;
SET character_set_results = UTF8;
SET character_set_connection = UTF8;