Windows操作(gbk)
mysql> select @@character_set_results;
+-------------------------+
| @@character_set_results |
+-------------------------+
| gbk |
+-------------------------+
1 row in set
mysql> select name_man from wsyy_marry where id = 1;
+----------+
| name_man |
+----------+
| 赫立广 |
+----------+
1 row in set
mysql> set @@session.character_set_results = 33;
Query OK, 0 rows affected
mysql> select @@character_set_results;
+-------------------------+
| @@character_set_results |
+-------------------------+
| utf8 |
+-------------------------+
1 row in set
mysql> select name_man from test.wsyy_marry where id = 1;
+----------+
| name_man |
+----------+
| 璧珛骞� |
+----------+
1 row in set
来源: http://www.cnblogs.com/jave1ove/p/7454966.html