hi i get a strange "can't create table 'databasename\bigdata1.frm' error 140" when i try to run the following create query:
DROP TABLE /*!32200 IF EXISTS*/ bigdata1; CREATE TABLE /*!32300 IF NOT EXISTS*/ bigdata1 ( IDData bigint(20) unsigned NOT NULL auto_increment, REFLang char(2) NOT NULL DEFAULT 'fr' , REFGeo bigint(20) unsigned NOT NULL DEFAULT '1' , REFChannel bigint(20) unsigned NOT NULL DEFAULT '1' , DataTitle varchar(255) binary NOT NULL DEFAULT '' , DataHeader varchar(255) binary NOT NULL DEFAULT '' , DataKeyWords varchar(255) binary NOT NULL DEFAULT '' , DateAdded timestamp(14) , ShortText1 varchar(255) binary , ShortText2 varchar(255) binary , ShortText3 varchar(255) binary , Number1 bigint(20), Number2 bigint(20), Number3 bigint(20), MediumText1 blob NOT NULL DEFAULT '', MediumText2 blob NOT NULL DEFAULT '', MediumText3 blob NOT NULL DEFAULT '', LongText1 longblob NOT NULL DEFAULT '', LongText2 longblob NOT NULL DEFAULT '', LongText3 longblob NOT NULL DEFAULT '', LongText4 longblob NOT NULL DEFAULT '', LongText5 longblob NOT NULL DEFAULT '', PRIMARY KEY (IDData), INDEX GlobalReference (REFLang, REFGeo, REFChannel), INDEX KeySearch (DataTitle(100), DataKeyWords(200), DataHeader(200)), FULLTEXT FullSearch (LongText1, LongText2, LongText3, LongText4, LongText5) ); anything wrong with my query ?? i'm using mysql 4.0.1alpha on WIn2k, Thanks _________________________________ Hassan El Forkani http://WarmAfrica.com EveryOne's Africa _________________________________ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php