MYSQL Character_set

1. Use gbk code, gbk connect, data insert; gbk/utf8 search result normal;

2. Use gbk code, utf8 connect, data insert; gbk/utf8 search result error;

3. Use utf8 code, gbk connect, data insert; gbk/utf8 search result error;

4. Use utf8 code, utf8 connect, data insert; gbk/utf8 search result normal;

Check character_set: show variables like '%char%';

Check table character_set: show create table <table name> \G;

Change session character_set: set name <character_set>;

database contains utf8 table and gbk table, use binary backup

character_set change using logic backup and recover;

database upgrade using logic backup and recover;

mysql logic backup: mysqldump

Character_set recommendation: using utf8