求助-网存空间转换全部中文都变了乱码

旧空间mysql版本 : MySQL 版本 4.1.14-standard

新空间mysql版本 : MySQL - 4.0.23-standard

把sql转过去时十分不成功 , 我转了5-6次了都是乱码
看过了不少贴,但解决不了问题,请求高手帮助

原来用的是什么字符集的？

原帖由 玻璃屋女孩 于 2006-8-2 15:58 发表
原来用的是什么字符集的？

程序是用BIG5的
空间方面不太了解

现在正在做

https://discuz.dismall.com/viewthread.php?tid=142050&extra=&page=1

但

1. BigDump: Staggered MySQL Dump Importer ver. 0.21b
   
2. Processing file: zohk_com.sql
   
3. 
   
4. Starting at the line: 3001
   
5. 
   
6. Error at the line 4192: INSERT INTO `cdb_members` (`uid`, `username`, `password`, `secques`, `gender`, `adminid`, `groupid`, `groupexpiry`, `extgroupids`, `regip`, `regdate`, `lastip`, `lastvisit`, `lastactivity`, `lastpost`, `posts`, `digestposts`, `oltime`, `pageviews`, `credits`, `extcredits1`, `extcredits2`, `extcredits3`, `extcredits4`, `extcredits5`, `extcredits6`, `extcredits7`, `extcredits8`, `avatarshowid`, `email`, `bday`, `sigstatus`, `tpp`, `ppp`, `styleid`, `dateformat`, `timeformat`, `pmsound`, `showemail`, `newsletter`, `invisible`, `timeoffset`, `newpm`, `accessmasks`, `money`, `bank`, `savemt`, `medals`, `pktime`, `logintime`, `fbem`, `bankstatus`, `bankmimi`, `bankpass`, `savemimi`, `useimages`, `getmoneytime`, `power`, `khtime`, `pay`, `fam`, `status`) VALUES (2084, 'Ôƺ£ÕùÆæit', '7d157f40590dc4e59a761b9fedfebf00', '', 0, 0, 14, 0, '', '24.172.180.197', 1144292486, '', 1144292486, 1144292486, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'morshnc@hotmail.com', '0000-00-00', 0, 0, 0, 0, '', 12, 0, 0, 1, 0, '+8', 0, 0, 100, 0, 0, '', 0, 0, 0, 0, 0, 8888, 0, 0, 0, 100, 0, 0, '', '');
   
7. 
   
8. Query: INSERT INTO `cdb_members` (`uid`, `username`, `password`, `secques`, `gender`, `adminid`, `groupid`, `groupexpiry`, `extgroupids`, `regip`, `regdate`, `lastip`, `lastvisit`, `lastactivity`, `lastpost`, `posts`, `digestposts`, `oltime`, `pageviews`, `credits`, `extcredits1`, `extcredits2`, `extcredits3`, `extcredits4`, `extcredits5`, `extcredits6`, `extcredits7`, `extcredits8`, `avatarshowid`, `email`, `bday`, `sigstatus`, `tpp`, `ppp`, `styleid`, `dateformat`, `timeformat`, `pmsound`, `showemail`, `newsletter`, `invisible`, `timeoffset`, `newpm`, `accessmasks`, `money`, `bank`, `savemt`, `medals`, `pktime`, `logintime`, `fbem`, `bankstatus`, `bankmimi`, `bankpass`, `savemimi`, `useimages`, `getmoneytime`, `power`, `khtime`, `pay`, `fam`, `status`) VALUES (2084, 'Ôƺ£ÕùÆæit', '7d157f40590dc4e59a761b9fedfebf00', '', 0, 0, 14, 0, '', '24.172.180.197', 1144292486, '', 1144292486, 1144292486, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'morshnc@hotmail.com', '0000-00-00', 0, 0, 0, 0, '', 12, 0, 0, 1, 0, '+8', 0, 0, 100, 0, 0, '', 0, 0, 0, 0, 0, 8888, 0, 0, 0, 100, 0, 0, '', '');
   
9. 
   
10. MySQL: Duplicate entry 'Ôƺ£ÕùÆÃ' for key 2
    
11. 
    
12. Stopped on error
    
13. 
    
14. Start from the beginning (DROP the old tables before restarting)
    
15. 
    
16. ?2003-2005 Alexey Ozerov - BigDump Home

复制代码

请问是独立主机吗？

原帖由 玻璃屋女孩 于 2006-8-2 16:13 发表
请问是独立主机吗？

只是网上租用空间而已，没有空间控制权

你参考一下这里的说明：
http://kb.discuz.com/index.php?t ... 3%E6%96%B9%E6%A1%88

昨天看过了~但只是升级没讲降级啊,我现在的情况应该是降级
不过都先谢谢你的回答