On Monday 20 January 2003 16:16, David T-G wrote: > create table pieces > ( > # ID number > id smallint unsigned not null default 0 auto_increment primary key , > title char(50) , > index (title) , > words text (4095) , > fulltext index (words(4095)) > ) ;
David, "words text (4095)" is incorrect definition of column. TEXT is a variable-length column type with the maximum size 64K: http://www.mysql.com/doc/en/Storage_requirements.html You should use [skip] ... words TEXT, FULLTEXT(words) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita 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