关于QQ本地农场数据导入错误，请高手高手指导

错误

SQL 查询 :  

CREATE TABLE `uchome_happyfarm_config` (

`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`uid` int( 11 ) NOT NULL DEFAULT '0',
`money` int( 11 ) DEFAULT '0',
`YB` int( 11 ) DEFAULT '0',
`JB` int( 11 ) DEFAULT '0',
`Message` text NOT NULL ,
`setting1` text CHARACTER SET utf8 NOT NULL ,
`setting2` text CHARACTER SET utf8 NOT NULL ,
`setting3` text CHARACTER SET utf8 NOT NULL ,
`setting4` text CHARACTER SET utf8 NOT NULL ,
`setting5` text CHARACTER SET utf8 NOT NULL ,
`setting6` text CHARACTER SET utf8 NOT NULL ,
`pf` int( 11 ) DEFAULT '0',
`vip` int( 11 ) DEFAULT '1',
PRIMARY KEY ( `id` )
)ENGINE = InnoDB DEFAULTCHARSET = latin1

MySQL 返回:


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,
  `setting2` text CHARACTER SET u


请问提示这样的错误应该怎么解决，谢谢，本人QQ124782809，求好心人帮助解决！

((em:14))都没有人出来的回答一下啦

((em:15))还是没有人回答啊