本帖最后由 tslbs 于 2010-5-12 00:38 编辑
数据表字段字符集和数据表的字符集不符 我是装的GBK的哪个啊
MySQL Error
Message: MySQL Query Error
SQL: CREATE TABLE uchome_award_info ( id int(4) unsigned NOT NULL auto_increment, awardno varchar(16) NOT NULL COMMENT '???????', awardname varchar(20) NOT NULL COMMENT '???????', credit int(4) NOT NULL COMMENT '????????', remain smallint(6) unsigned default '0' COMMENT '???????', exchange smallint(6) unsigned default '0' COMMENT '????????', isopen tinyint(1) NOT NULL COMMENT '??????? 1???????? 0????????', awardimg varchar(255) NOT NULL COMMENT '?????', description text NOT NULL COMMENT '???????', orders int(4) default NULL COMMENT '????', PRIMARY KEY (id)) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=gbk COLLATE=gbk_bin COMMENT='??????????? AUTO_INCREMENT=3
Error: 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 ''??????????? AUTO_INCREMENT=3' at line 1
Errno.: 1064
Click here to seek help. |
