gaouzief, Wednesday, March 06, 2002, 6:28:01 PM, you wrote: g> i get a strange "can't create table 'databasename\bigdata1.frm' g> error 140" when i try to run the following create query:
g> DROP TABLE /*!32200 IF EXISTS*/ bigdata1; g> CREATE TABLE /*!32300 IF NOT EXISTS*/ bigdata1 ( g> IDData bigint(20) unsigned NOT NULL auto_increment, g> REFLang char(2) NOT NULL DEFAULT 'fr' , g> REFGeo bigint(20) unsigned NOT NULL DEFAULT '1' , g> REFChannel bigint(20) unsigned NOT NULL DEFAULT '1' , g> DataTitle varchar(255) binary NOT NULL DEFAULT '' , g> DataHeader varchar(255) binary NOT NULL DEFAULT '' , g> DataKeyWords varchar(255) binary NOT NULL DEFAULT '' , g> DateAdded timestamp(14) , g> ShortText1 varchar(255) binary , g> ShortText2 varchar(255) binary , g> ShortText3 varchar(255) binary , g> Number1 bigint(20), g> Number2 bigint(20), g> Number3 bigint(20), g> MediumText1 blob NOT NULL DEFAULT '', g> MediumText2 blob NOT NULL DEFAULT '', g> MediumText3 blob NOT NULL DEFAULT '', g> LongText1 longblob NOT NULL DEFAULT '', g> LongText2 longblob NOT NULL DEFAULT '', g> LongText3 longblob NOT NULL DEFAULT '', g> LongText4 longblob NOT NULL DEFAULT '', g> LongText5 longblob NOT NULL DEFAULT '', g> PRIMARY KEY (IDData), g> INDEX GlobalReference (REFLang, REFGeo, REFChannel), g> INDEX KeySearch (DataTitle(100), DataKeyWords(200), DataHeader(200)), g> FULLTEXT FullSearch (LongText1, LongText2, LongText3, LongText4, LongText5) g> ); g> anything wrong with my query ?? g> i'm using mysql 4.0.1alpha on WIn2k, According to MySQL manual, you can create fulltext index only on VARCHAR and TEXT columns. g> Thanks -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- 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
