求救,这是什么错误?我的sql数据库4.0.21,错误提示如下:
SQL 查询:
CREATE TABLE `renren_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 ,
`farm_log` text CHARACTER SET utf8 NOT NULL ,
`wenzi` text CHARACTER SET utf8 NOT NULL ,
`bad` int( 10 ) NOT NULL default '0',
`mc_chat` text CHARACTER SET utf8 NOT NULL ,
`log` text CHARACTER SET utf8 NOT NULL ,
PRIMARY KEY ( `uid` ) ) ENGINE = MYISAM DEFAULT CHARSET = gbk
MySQL 返回:
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'character set utf8 NOT NULL,
`animal` text character set utf |