We are in the process of migrating this forum. A new space will be available soon. We are sorry for the inconvenience.

MySql 4.0


kinimod
24-01-2008, 21:00
Mam problem z zapytaniem:

# Table: 'phpbb_attachments'
ALTER TABLE phpbb_attachments
MODIFY attach_id mediumint(8) UNSIGNED NOT NULL auto_increment,
MODIFY post_msg_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY in_message tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY poster_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY is_orphan tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY physical_filename varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY real_filename varchar(255) DEFAULT '' NOT NULL utf8_bin,
MODIFY download_count mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY attach_comment text NOT NULL COLLATE utf8_bin,
MODIFY extension varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY mimetype varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY filesize int(20) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY filetime int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY thumbnail tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

które wywala mi bład postaci:
#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,
MODIFY real_filename varchar(255) DEFAULT ''

Gdzieś przeczytałem, że to wina wersji MySql, tylko nie wiem za bardzo jak to poprawić, jeśli ktoś ma pomysł to z góry dzięki