Do you have a headache for getting MySQL to change the character set? Do not worry, the following article will give you the correct solution, the following article is mainly introduced to obtain the MySQL change character set scheme, the following is the specific description of the relevant content.
ROR+MYSQL5 UTF8 collocation Problem Solving solution
C # +mysqldriver.dll garbled problem
1, with the SET syntax to specify, do not add "GLOBAL" is only valid for this session.
SET [GLOBAL] character_set_client = UTF8; SET [GLOBAL] character_set_connection = UTF8; SET [GLOBAL] character_set_database = UTF8; SET [GLOBAL] character_set_results = UTF8; SET [GLOBAL] character_set_server = UTF8;
2. Only valid for this session.
SET NAMES ' UTF8 ';
3, directly modify My.cnf,[client] and [MySQLd] below each add a line of content, and then restart MySQL, the global effective.
Default-character-set = UTF8
The above related content is to the MySQL change character set introduction, hope you can have the harvest.