mysql版解决不了,希望这里有人看看吧,解决不了今晚睡不了

[alasika]

mysql5导出来的表,是乱码来的,如下

DROP TABLE IF EXISTS `pw_banuser`;
CREATE TABLE `pw_banuser` (
`uid` mediumint(8) unsigned NOT NULL default '0',
`type` tinyint(1) NOT NULL default '0',
`startdate` int(10) NOT NULL default '0',
`days` int(4) NOT NULL default '0',
`admin` char(15) NOT NULL default '',
`reason` char(80) NOT NULL default '',
PRIMARY KEY (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=gb2312;

--
-- Dumping data for table `pw_banuser`
--


/*!40000 ALTER TABLE `pw_banuser` DISABLE KEYS */;
LOCK TABLES `pw_banuser` WRITE;
INSERT INTO `pw_banuser` VALUES (4291,1,1104923095,5,'hnlfw','???e?ú×ê?′°??D?￠1???.ì??é°??éê?ר???￠1???ê?μ???.'),(1869,2,1104146010,0,'admin',''),(4316,1,1104928955,10,'caokao',''),(4594,1,1108626899,10,'ê????×','ó?ê???￡??ò?μ1y?íê???ê?￡??????′???′?2????è?￡??ó±?10ìì'),(5875,2,1106572951,1,'porty',''),(5868,2,1106716284,30,'porty',''),(4143,2,1107146603,0,'porty',''),(6272,2,1107178171,0,'porty',''),(8641,1,1107938622,30,'??×ó??',''),(8993,1,1108389633,3,'porty','óéóú??μ?′|?￠1???ìù￡?1ì???1?￠??3ìì'),(5283,1,1108632407,3,'ê????×','??òa?-??ìù￡?3ìì????￡?'),(13454,1,1110455013,10,'hnlfw',''),(9917,1,1108714979,10,'hnlfw',''),(9776,1,1108828068,3,'porty',''),(8593,1,1108899648,10,'hnlfw',''),(10047,1,1108899989,10,'hnlfw',''),(11621,1,1109729704,10,'ê????×','?ù???′?D?ó1???￡?D??ê??áó￡?'),(10845,1,1109729861,10,'ê????×','??2??e￡??aà???óD???2??μ???ì3D?ê?￡?get out pls￡?￡?￡?'),(5290,1,1109903915,10,'hnlfw',''),(10189,1,1110202555,20,'hully','?￠2?1???'),(10390,1,1110596376,10,'hnlfw',''),(13818,1,1110620144,10,'ê????×',''),(14055,1,1110718818,1,'exactly','?￠á?4???ó?úì?￡?è?ê?òa??μ?'),(11816,1,1110891137,3,'rani1981','???￥1?ì?í?￡?í???o???é?3é?Y￡??????áá?ìùí????òoó2?à′1aáù￡?è?óDòé?ê???￠???￠áa?μ?ò?￡'),(14072,1,1111295294,20,'hully','');
UNLOCK TABLES;
/*!40000 ALTER TABLE `pw_banuser` ENABLE KEYS */;



因为mysql4不支持CREATE TABLE () default charset gb2312,所以我把default charset gb2312删了,然后能导入到mysql4中,但查询出来却是乱码!!! 求救呀
我要怎样才能把这些乱码变成中文?????
或者要怎样才可以查出来变成中文????

这些是不是latin字符??? 我郁闷死了,各位达人大哥大姐,救命呀

[fyxw]

用文件导行不行呢？

[lawyu]

看看phpMyAdmin里环境变量里charset的设置

[cokeyang]

你导出来的时候用可以选择字符集吗？

[alasika]

谢谢大家,的确是导出的时侯应该选择字符集, 问题解决了,下班前结贴

mysqldump Database > data.dump --default-charset-set=utf8

[alasika]

用mysqldump是不是能导出中文?? mysqldump 有个 default-charactor-set 的选项,但我试过不行
呀

[nne998]

用phpmyadmin来导

[ashchen]

utf8，gb2312 的问题mysql根本没解决好，日

[alasika]

用phpmyadmin导也一样,是不是有些什么特殊设置的??

想知道怎样才能转换成正常的中文字呀,任何方法都行,有谁知道吗??

[yinzhj_2002cn]

可以直接使用命令mysqldump 的default-charset-set选项，从Mysql5中dump出.sql文件，在使用mysql dbName(mysql4的)< mysql5.sql，应该就可以了呀，我常用的。

[zhutimy]

导出后,将浏览器的编码改成简体中文试试

[coolstr]

用phpmyadmin导的话，首先要在首页把编码设置成你数据库的编码，然后再导就完全OK啦。

[fengzehao]

用文本打开，存为utf8格式 ！！！