开心农场問題help[誰人能幫忙解決我即送10金給他]

数据库怎么导入的啊，我导入不成

不知與升級數據有沒有關係

CREATE TABLE `uchome_plug_newfarm` (
  `uid` mediumint(8) NOT NULL,
  `farmlandstatus` text character set utf8 NOT NULL,
  `animal` text character set utf8 NOT NULL,
  `taskid` int(2) NOT NULL default '1',
  `charm` int(10) NOT NULL default '0',
  `money` int(10) NOT NULL default '0',
  `exp` int(10) NOT NULL default '0',
  `mc_exp` int(10) NOT NULL default '0',
  `fb` int(10) NOT NULL default '0',
  `reclaim` smallint(2) NOT NULL default '6',
  `package` text character set utf8 NOT NULL,
  `mc_package` text character set utf8 NOT NULL,
  `fertilizer` text character set utf8 NOT NULL,
  `decorative` text character set utf8 NOT NULL,
  `fruit` text character set utf8 NOT NULL,
  `dog` text character set utf8 NOT NULL,
  `nosegay` text character set utf8 NOT NULL,
  `message` text character set utf8 NOT NULL,
  `mc_taskid` int(2) NOT NULL default '0',
  `mc_taskid1` int(2) NOT NULL default '0',
  `mc_log` text character set utf8 NOT NULL,
  PRIMARY KEY  (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=big5;

導出後顯示為

DROP TABLE IF EXISTS uchome_plug_newfarm;
CREATE TABLE uchome_plug_newfarm (
  uid mediumint(8) NOT NULL,
  farmlandstatus text NOT NULL,
  animal text NOT NULL,
  taskid int(2) NOT NULL default '1',
  charm int(10) NOT NULL default '0',
  money int(10) NOT NULL default '0',
  exp int(10) NOT NULL default '0',
  mc_exp int(10) NOT NULL default '0',
  fb int(10) NOT NULL default '0',
  reclaim smallint(2) NOT NULL default '6',
  package text NOT NULL,
  mc_package text NOT NULL,
  fertilizer text NOT NULL,
  decorative text NOT NULL,
  fruit text NOT NULL,
  dog text NOT NULL,
  nosegay text NOT NULL,
  message text NOT NULL,
  mc_taskid int(2) NOT NULL default '0',
  mc_taskid1 int(2) NOT NULL default '0',
  mc_log text NOT NULL,
  PRIMARY KEY  (uid)
) ENGINE=MyISAM DEFAULT CHARSET=big5;

江xml改為big5另存新檔編碼選 utf8 試試

江xml改為big5另存新檔編碼選 utf8 試試
dodob29 发表于 2009-10-21 23:10

剛剛已測試了,但還是出現空白

1. 
   
2. CREATE TABLE `uchome_plug_newfarm` (
   
3.   `uid` mediumint(8) NOT NULL,
   
4.   `farmlandstatus` text character set big5 NOT NULL,
   
5.   `animal` text character set big5 NOT NULL,
   
6.   `taskid` int(2) NOT NULL default '1',
   
7.   `charm` int(10) NOT NULL default '0',
   
8.   `money` int(10) NOT NULL default '0',
   
9.   `exp` int(10) NOT NULL default '0',
   
10.   `mc_exp` int(10) NOT NULL default '0',
    
11.   `fb` int(10) NOT NULL default '0',
    
12.   `reclaim` smallint(2) NOT NULL default '6',
    
13.   `package` text character set big5 NOT NULL,
    
14.   `mc_package` text character set big5 NOT NULL,
    
15.   `fertilizer` text character set big5 NOT NULL,
    
16.   `decorative` text character set big5 NOT NULL,
    
17.   `fruit` text character set big5 NOT NULL,
    
18.   `dog` text character set big5 NOT NULL,
    
19.   `nosegay` text character set big5 NOT NULL,
    
20.   `message` text character set big5 NOT NULL,
    
21.   `mc_taskid` int(2) NOT NULL default '0',
    
22.   `mc_taskid1` int(2) NOT NULL default '0',
    
23.   `mc_log` text character set big5 NOT NULL,
    
24.   PRIMARY KEY  (`uid`)
    
25. ) ENGINE=MyISAM DEFAULT CHARSET=big5;
    

复制代码

24# 8783

Test This...

hotllus 发表于 2009-10-21 23:15

   
也是出現空白,導出後像22#一樣

Maybe 要 Super Man Help~~~

你是这样转码的吗？
先将内容utf8简转为utf8繁
然后储存为big5
这样做试试看吧～

Maybe 要 Super Man Help~~~
hotllus 发表于 2009-10-21 23:20

先多謝各方協助了