How to modify the default Character Set of MySQL

Modify the default MySQL Character Set Method, generally even if you set the default mysql Character Set of the table to utf8 and send the query by UTF-8 encoding, you will find that the stored in the database is still messy

Modify the default MySQL Character Set Method, generally even if you set the default mysql Character Set of the table to utf8 and send the query by UTF-8 encoding, you will find that the stored in the database is still messy

Set names 'utf8 ';

(1) The simplest modification method is to modify the character set key value in mysql's my. ini file,

For example, default-character-set = utf8

Character_set_server = utf8

After modification, restart the mysql service, service mysql restart

Use mysql> show variables like 'character % '; Check that the database encoding has been changed to utf8

+ -------------------------- + ----------------------------------- +

| 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 default Character Set of mysql is to use the mysql command.

SQL code

Mysql> SET character_set_client = utf8; mysql> SET character_set_connection = utf8; mysql> SET character_set_database = utf8; mysql> SET character = utf8; mysql> SET character_set_server = utf8; mysql> SET collation_connection = utf8; mysql> SET collation_database = utf8; mysql> SET collation_server = utf8;

Generally, even if you set the default mysql Character Set of the table to utf8 and send the query by UTF-8 encoding, you will find that the database is still garbled. The problem lies in the connection layer. The solution is to execute the following statement before sending the query:

SQL code

Set names 'utf8 ';

It is equivalent to the following three commands:

SQL code