mysql> show character set like '%gbk%';
+---------+------------------------+-------------------+--------+
| Charset | Description | Default collation | Maxlen |
+---------+------------------------+-------------------+--------+
| gbk | GBK Simplified Chinese | gbk_chinese_ci | 2 | 
+---------+------------------------+-------------------+--------+
1 row in set (0.00 sec)

mysql> show collation like '%gbk%';
+----------------+---------+----+---------+----------+---------+
| Collation | Charset | Id | Default | Compiled | Sortlen |
+----------------+---------+----+---------+----------+---------+
| gbk_chinese_ci | gbk | 28 | Yes | Yes | 1 | 
| gbk_bin | gbk | 87 | | Yes | 1 | 
+----------------+---------+----+---------+----------+---------+
2 rows in set (0.00 sec)

mysql> show variables like 'character\_set\_%';
+--------------------------+--------+
| Variable_name | Value |
+--------------------------+--------+
| character_set_client | latin1 | 
| character_set_connection | latin1 | 
| character_set_database | gbk | 
| character_set_filesystem | binary | 
| character_set_results | latin1 | 
| character_set_server | gbk | 
| character_set_system | utf8 | 
+--------------------------+--------+
7 rows in set (0.01 sec)

mysql> show variables like 'collation\_%'; 
+----------------------+-------------------+
| Variable_name | Value |
+----------------------+-------------------+
| collation_connection | latin1_swedish_ci | 
| collation_database | gbk_chinese_ci | 
| collation_server | gbk_chinese_ci | 
+----------------------+-------------------+
3 rows in set (0.00 sec)

set character_set_client = utf8;
set character_set_results = utf8;
set character_set_connection = utf8;

set names 'utf8';