Ladies & Gentlemen, The manual says "FULLTEXT indexes are used with MyISAM tables and can be created from VARCHAR and TEXT columns at CREATE TABLE time or added later with ALTER TABLE or CREATE INDEX."
I get the following error when I try to add a full text index for a mediumblob column - but not when I add it to any other columns - mysql> alter table knowledge add fulltext (k_body); ERROR 1005: Can't create table './preferred/#sql-c2_44.frm' (errno: 140) If it is true I can't use full text on a medium blob - can I do it on a mediumtext field? Is there a way to convert a column from one to the other? Thanks, Aaron myql --------------------------------------------------------------------- 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
