SQL error！

>>> database：bbpress (localhost)

>>>>>> CREATE TABLE IF NOT EXISTS bb_posts (

post_id bigint(20) NOT NULL auto_increment,

forum_id int(10) NOT NULL default 1,

topic_id bigint(20) NOT NULL default 1,

poster_id int(10) NOT NULL default 0,

post_text text NOT NULL,

post_time datetime NOT NULL default ‘0000-00-00 00:00:00’,

poster_ip varchar(15) NOT NULL default ”,

post_status tinyint(1) NOT NULL default 0,

post_position bigint(20) NOT NULL default 0,

PRIMARY KEY (post_id),

KEY topic_time (topic_id, post_time),

KEY poster_time (poster_id, post_time),

KEY post_time (post_time),

FULLTEXT KEY post_text (post_text)

) TYPE = MYISAM DEFAULT CHARACTER SET ‘utf8’;

>>>>>> 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 ‘TYPE = MYISAM DEFAULT CHARACTER SET ‘utf8” at line 16

[@zaerl Participant 14 years, 8 months ago]

Probably you have a very old version of MySQL, something like v3.20 which doesn’t support utf8. What version are you using?

[@zaerl Participant 14 years, 8 months ago]

Probably you have a very old version of MySQL, something like v3.20 which doesn’t support utf8. What version are you using?

[@jzp820927 Member 14 years, 8 months ago]

Apache version：2.2.17 (Win32)

PHP version：php-5.3.5-Win32-VC6-x86

Mysql version：MySQL Community Server 5.5.8

OS：Win XP pro SP3

[@jzp820927 Member 14 years, 8 months ago]

Apache version：2.2.17 (Win32)

PHP version：php-5.3.5-Win32-VC6-x86

Mysql version：MySQL Community Server 5.5.8

OS：Win XP pro SP3