竹貓星球

代碼: 選擇全部

錯誤
SQL 語法:

CREATE TABLE phpbb_shoutbox(
shout_id INT( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
shout_user_id MEDIUMINT( 8 ) NOT NULL ,
shout_time INT( 11 ) NOT NULL ,
shout_ip VARCHAR( 32 ) CHARACTER SET latin1 NOT NULL ,
shout_text TEXT COLLATE utf8_bin NOT NULL ,
shout_bbcode_bitfield VARCHAR( 255 ) CHARACTER SET latin1 NOT NULL ,
shout_bbcode_uid VARCHAR( 8 ) CHARACTER SET latin1 NOT NULL ,
shout_bbcode_flags INT( 11 ) UNSIGNED NOT NULL DEFAULT  '7',
PRIMARY KEY ( shout_id )
) DEFAULT CHARSET = utf8 COLLATE = utf8_bin

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 'collate utf8_bin NOT NULL,
  shout_bbcode_bitfield varchar(255