access2003里的表通过odbc导入到mysql后，显示的汉子记录是乱码

Question

access的表已通过odbc成功导入到了mysql里，然后在mysql里select 表内所有字段，显示的记录中汉子部分全部是乱码。mysql的字符集是：
+--------------------------+-------------------------------------------+
| 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                                      |

Answer 1

这应该没什么问题啊，
关键在于你创建的mysql数据源，高级里头，把charset选择为gbk即可。没什么问题的。

Answer 2

把编码改为gbk就没有问题了。