Obtain the MySQL Character Set Change Solution

Are you very worried about getting MySQL to change the character set? Don't worry. The following articles will give you a correct solution. The following articles mainly introduce the solution for changing the character set of MySQL. The following describes the specific content.

ROR + MySQL5 utf8 with problem solution

C # + MySQLDriver. dll garbled

1. Use the SET syntax to specify the value. If "GLOBAL" is not added, the value 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 = utf8; SET [GLOBAL] character_set_server = utf8;

2. valid only for this session.

Set names 'utf8 ';

3. directly modify my. cnf, [client], and [MySQLd] to add a line of content, and then restart MySQL to take effect globally.

Default-character-set = utf8

The above content is an introduction to changing the character set of MySQL. I hope you will have some gains.