I'm not sure about not being able to put FULLTEXT on blobs, but it would make sense that it only works on specifically text fields. Here is the syntax to change the column type (this may affect the data stored so you might want to dump the data and reimport after you have changed the column type)
mysql> alter table tablename change field field newtype ; --Joe -- Joe Stump Affordable Computers, Inc. 800-864-2345 x113 ----- Original Message ----- From: "Aaron Merrick" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, November 01, 2002 4:25 PM Subject: Fulltext index on a mediumblob column? > 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 > > --------------------------------------------------------------------- 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
