MySQL Character set and collation

Summarize:

Utf8_unicode_ci and Utf8_general_ci have no real difference between Chinese and English.
Utf8_general_ci proofreading speed is fast, but the accuracy is slightly worse.
Utf8_unicode_ci accuracy is high, but the proofreading speed is slightly slower.

Add the following parameters to the MY.CNF

[mysqld]init_connect= ' SET NAMES utf8′default-character-set=utf8default-collation = utf8_general_ci

Execute Query mysql> show variables

character_set_client | UTF8 Character_set_connection | UTF8 Character_set_database | UTF8 Character_set_results | UTF8 Character_set_server | UTF8 Character_set_system | utf8collation_connection | Utf8_general_ci Collation_database | Utf8_general_ci Collation_server | Utf8_general_ci

MySQL Character set and collation