Bericht
door wiiwant2play » 23 feb 2008, 22:34
Ik krijg een fout melding in de SQL QUERY
SQL-query:
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 retourneerde: Documentatie
#1064 - You have an error in your SQL syntax near 'character set latin1 NOT NULL,
shout_text text collate utf8_bin NOT NULL,
' at line 5
Weet iemand waar dit aan ligt ?
Waarom ben ik altijd de pineut.
Dat is de ON knop