Apache : 2.2.6
PHP : 4.4.7
mySQL : 4.0.27
小弟今天在安裝 Ajax Shoutbox 的時候
在建立 SQL table 時就遇到問題了！
不知道是不是 mysql 版本不合的關係
代碼: 選擇全部
錯誤
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
