sql server2000数据导入mysql问题

Question

请教大虾，表导入后，数据要么就丢失，要么就乱码（数据也丢失很多），怎么解决？
在线等~~谢谢！

Answer 1

请教hy2003fly()  
 
首先你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> show variables like '%char%';
显示出来的
+--------------------------+--------------------------+
| Variable_name            | Value                    |
+--------------------------+--------------------------+
| character_set_client     | gb2312                   |
| character_set_connection | gb2312                   |
| character_set_database   | gb2312                   |
| character_set_filesystem | binary                   |
| character_set_results    | gb2312                   |
| character_set_server     | gb2312                   |
| character_set_system     | utf8                     |
| character_sets_dir       | d:\mysql\share\charsets\ |
+--------------------------+--------------------------+
8 rows in set (0.08 sec)何解？能告知原因吗？
 

Answer 2

上面的字符集设置已经可以了.使用mysql marigation tool kit这个图形工具来导过去,导的过程中要注意设置字集集的参数,否则会出现乱码.存储过程,我没有导过不清楚会有什么结果.