本帖最后由 hotllus 于 2009-10-24 12:06 编辑
1# BIMAZI
请问您的升级语句是不是这个:
- 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=gbk;
复制代码
如果是,请删除改为以下,但不确保一定可解决(All UTF8 Chang to GBK):
- CREATE TABLE `uchome_plug_newfarm` (
- `uid` mediumint(8) NOT NULL,
- `farmlandstatus` text character set gbk NOT NULL,
- `animal` text character set gbk 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 gbk NOT NULL,
- `mc_package` text character set gbk NOT NULL,
- `fertilizer` text character set gbk NOT NULL,
- `decorative` text character set gbk NOT NULL,
- `fruit` text character set gbk NOT NULL,
- `dog` text character set gbk NOT NULL,
- `nosegay` text character set gbk NOT NULL,
- `message` text character set gbk NOT NULL,
- `mc_taskid` int(2) NOT NULL default '0',
- `mc_taskid1` int(2) NOT NULL default '0',
- `mc_log` text character set gbk NOT NULL,
- PRIMARY KEY (`uid`)
- ) ENGINE=MyISAM DEFAULT CHARSET=gbk;
复制代码 |