我从mysql4.17数据库导出.然后 导入到mysql5.0.27数据库里.访问网站出现乱码.

???é?????÷??
topic : 15	post : 26	today : 0
版主: 最后发表:???í??×?

请问这个应该怎么处理.???
在线等...

编码问题！
导出之后，打开这个大文件，修改每个表定义后面的character set

大哥.可以说清楚一点么.小弟不大懂..

下面是我数据库的一部份.

-- Table structure for table `adv_broker`
--

CREATE TABLE adv_broker (
id mediumint(8) unsigned NOT NULL auto_increment,
uid mediumint(8) unsigned NOT NULL default '0',
username varchar(15) NOT NULL default '',
dianshu int(10) NOT NULL default '0',
updatetime int(10) unsigned NOT NULL default '0',
PRIMARY KEY (id),
KEY username (username)
) TYPE=MyISAM;

--
-- Dumping data for table `adv_broker`
--


--
-- Table structure for table `cdb_access`
--

CREATE TABLE cdb_access (
uid mediumint(8) unsigned NOT NULL default '0',
fid smallint(6) unsigned NOT NULL default '0',
allowview tinyint(1) NOT NULL default '0',
allowpost tinyint(1) NOT NULL default '0',
allowreply tinyint(1) NOT NULL default '0',
allowgetattach tinyint(1) NOT NULL default '0',
allowpostattach tinyint(1) NOT NULL default '0',
PRIMARY KEY (uid,fid)
) TYPE=MyISAM;

--
-- Dumping data for table `cdb_access`
--


--
-- Table structure for table `cdb_activities`
--

CREATE TABLE cdb_activities (
tid mediumint(8) unsigned NOT NULL default '0',
uid mediumint(8) unsigned NOT NULL default '0',
cost mediumint(8) unsigned NOT NULL default '0',
starttimefrom int(10) unsigned NOT NULL default '0',
starttimeto int(10) unsigned NOT NULL default '0',
place char(40) NOT NULL default '',
class char(20) NOT NULL default '',
gender tinyint(1) NOT NULL default '0',
number smallint(5) unsigned NOT NULL default '0',
expiration int(10) unsigned NOT NULL default '0',
PRIMARY KEY (tid),
KEY uid (uid,starttimefrom)
) TYPE=MyISAM;

--
-- Dumping data for table `cdb_activities`
--


--
-- Table structure for table `cdb_activityapplies`
--

CREATE TABLE cdb_activityapplies (
applyid int(10) unsigned NOT NULL auto_increment,
tid mediumint(8) unsigned NOT NULL default '0',
username char(15) NOT NULL default '',
uid mediumint(8) unsigned NOT NULL default '0',
message char(200) NOT NULL default '',
verified tinyint(1) NOT NULL default '0',
dateline int(10) unsigned NOT NULL default '0',
payment mediumint(8) NOT NULL default '0',
contact char(200) NOT NULL default '',
PRIMARY KEY (applyid),
KEY uid (uid),
KEY tid (tid),
KEY dateline (tid,dateline)
) TYPE=MyISAM;

--
-- Dumping data for table `cdb_activityapplies`
--


--
-- Table structure for table `cdb_adminactions`
--

CREATE TABLE cdb_adminactions (
admingid smallint(6) unsigned NOT NULL default '0',
disabledactions text NOT NULL,
PRIMARY KEY (admingid)
) TYPE=MyISAM;

--
-- Dumping data for table `cdb_adminactions`
--


--
-- Table structure for table `cdb_admingroups`
--

CREATE TABLE cdb_admingroups (
admingid smallint(6) unsigned NOT NULL default '0',
alloweditpost tinyint(1) NOT NULL default '0',
alloweditpoll tinyint(1) NOT NULL default '0',
allowstickthread tinyint(1) NOT NULL default '0',
allowmodpost tinyint(1) NOT NULL default '0',
allowdelpost tinyint(1) NOT NULL default '0',
allowmassprune tinyint(1) NOT NULL default '0',
allowrefund tinyint(1) NOT NULL default '0',
allowcensorword tinyint(1) NOT NULL default '0',
allowviewip tinyint(1) NOT NULL default '0',
allowbanip tinyint(1) NOT NULL default '0',
allowedituser tinyint(1) NOT NULL default '0',
allowmoduser tinyint(1) NOT NULL default '0',
allowbanuser tinyint(1) NOT NULL default '0',
allowpostannounce tinyint(1) NOT NULL default '0',
allowviewlog tinyint(1) NOT NULL default '0',
disablepostctrl tinyint(1) NOT NULL default '0',
supe_allowpushthread tinyint(1) NOT NULL default '0',
PRIMARY KEY (admingid)
) TYPE=MyISAM;

--
-- Dumping data for table `cdb_admingroups`
--


--
-- Table structure for table `cdb_adminnotes`
--

CREATE TABLE cdb_adminnotes (
id mediumint(8) unsigned NOT NULL auto_increment,
admin varchar(15) NOT NULL default '',
access tinyint(3) NOT NULL default '0',
adminid tinyint(3) NOT NULL default '0',
dateline int(10) unsigned NOT NULL default '0',
expiration int(10) unsigned NOT NULL default '0',
message text NOT NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;

--
-- Dumping data for table `cdb_adminnotes`
--


--
-- Table structure for table `cdb_adminsessions`
--

CREATE TABLE cdb_adminsessions (
uid mediumint(8) unsigned NOT NULL default '0',
ip char(15) NOT NULL default '',
dateline int(10) unsigned NOT NULL default '0',
errorcount tinyint(1) NOT NULL default '0'
) TYPE=MyISAM;

--
-- Dumping data for table `cdb_adminsessions`
--


--
-- Table structure for table `cdb_advertisements`
--

CREATE TABLE cdb_advertisements (
advid mediumint(8) unsigned NOT NULL auto_increment,
available tinyint(1) NOT NULL default '0',
type varchar(50) NOT NULL default '0',
displayorder tinyint(3) NOT NULL default '0',
title varchar(50) NOT NULL default '',
targets text NOT NULL,
parameters text NOT NULL,
code text NOT NULL,
starttime int(10) unsigned NOT NULL default '0',
endtime int(10) unsigned NOT NULL default '0',
PRIMARY KEY (advid)
) TYPE=MyISAM;

--
-- Dumping data for table `cdb_advertisements`
--


--
-- Table structure for table `cdb_announcements`
--

CREATE TABLE cdb_announcements (
id smallint(6) unsigned NOT NULL auto_increment,
author varchar(15) NOT NULL default '',
subject varchar(250) NOT NULL default '',
type tinyint(1) NOT NULL default '0',
displayorder tinyint(3) NOT NULL default '0',
starttime int(10) unsigned NOT NULL default '0',
endtime int(10) unsigned NOT NULL default '0',
message text NOT NULL,
groups text NOT NULL,
PRIMARY KEY (id),
KEY timespan (starttime,endtime)
) TYPE=MyISAM;

--
-- Dumping data for table `cdb_announcements`
--


--
-- Table structure for table `cdb_attachments`
--

CREATE TABLE cdb_attachments (
aid mediumint(8) unsigned NOT NULL auto_increment,
tid mediumint(8) unsigned NOT NULL default '0',
pid int(10) unsigned NOT NULL default '0',
dateline int(10) unsigned NOT NULL default '0',
readperm tinyint(3) unsigned NOT NULL default '0',
price smallint(6) unsigned NOT NULL default '0',
filename char(100) NOT NULL default '',
description char(100) NOT NULL default '',
filetype char(50) NOT NULL default '',
filesize int(10) unsigned NOT NULL default '0',
attachment char(100) NOT NULL default '',
downloads mediumint(8) NOT NULL default '0',
isimage tinyint(1) unsigned NOT NULL default '0',
uid mediumint(8) unsigned NOT NULL default '0',
thumb tinyint(1) unsigned NOT NULL default '0',
remote tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (aid),
KEY tid (tid),
KEY pid (pid,aid),
KEY uid (uid)
) TYPE=MyISAM;

--
-- Dumping data for table `cdb_attachments`
--


--
-- Table structure for table `cdb_attachpaymentlog`
--

CREATE TABLE cdb_attachpaymentlog (
uid mediumint(8) unsigned NOT NULL default '0',
aid mediumint(8) unsigned NOT NULL default '0',
authorid mediumint(8) unsigned NOT NULL default '0',
dateline int(10) unsigned NOT NULL default '0',
amount int(10) unsigned NOT NULL default '0',
netamount int(10) unsigned NOT NULL default '0',
PRIMARY KEY (aid,uid),
KEY uid (uid),
KEY authorid (authorid)
) TYPE=MyISAM;

--
-- Dumping data for table `cdb_attachpaymentlog`
--


--
-- Table structure for table `cdb_attachtypes`
--

CREATE TABLE cdb_attachtypes (
id smallint(6) unsigned NOT NULL auto_increment,
extension char(12) NOT NULL default '',
maxsize int(10) unsigned NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;

通过PHPMYAdmin？我遇到过这种情况，不过是因为PhPMyAdmin版本差别才有乱码

如果直接复制数据库文件，应该没什么问题吧

http://blog.csdn.net/liujincheng ... /02/28/1517226.aspx

这是windows环境下的解决办法，应该可以借鉴一下

应该就是字符集的问题

谢谢.先测试下.

如果从mysql5到4.0，那才改的累死呢。。