(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, discover that the database encoding has been changed to UTF8
mysql> show variables like ' character% '; +--------------------------+------------------- --------------+ | 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) Another way to modify the MySQL default character set is to use the MySQL command
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 = u Tf8;mysql> SET collation_server = UTF8;
In general, even if you set the table MySQL default character set is UTF8 and send the query through 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:
SET NAMES ' UTF8 ';
It is equivalent to the following three-sentence instruction:
SET character_set_client = UTF8; SET character_set_results = UTF8; SET character_set_connection = UTF8;
This article is from the "Small Box" blog, please be sure to keep this source http://zhangxiaohe.blog.51cto.com/7821029/1545477
MySQL modifies the character set.