用MySQL Migration Toolkit工具把sql server2000..

用MySQL Migration Toolkit工具把sql server2000的表导到mysql中,
中文乱码问题的处理方法!

先下载 mysql-gui-tools-5.0-r4-win32.msi
首先你mysql的字符集应该设置成这样:
mysql> show variables like '%char%';
+--------------------------+--------------------------+
| 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                     |
| character_sets_dir       | d:\mysql\share\charsets\ |
+--------------------------+--------------------------+
8 rows in set (0.08 sec)

然后,用使用mysql marigation toolkit, 一直到出现Set Parameter那个界面,点击进去,选择user defined,加入charset=utf8, collation= utf8_general_ci
这样设置好后,就不会出现乱码了.

-----------------------------------------

操作到Object Mapping(可以从左边的流程图上看到)这一步,界面右边就会有一个"Set Parameter>>"的按钮,点击进去里面设好就可以了

--------------------------------------

我的就五步,我用的是MySQL Migration Toolkit,
1.连接SQL SERVER.
2.连接Mysql.
3.选择数据库.
4.选择表.
5.数据库转换进度.