Thanks Paul - it worked perfectly. And for anyone else listening, modifying the table did not adversely affect the data (although I did back up just in case). --Aaron
On 11/1/02 7:34 PM, "Paul DuBois" <[EMAIL PROTECTED]> wrote: > At 15:25 -0600 11/1/02, Aaron Merrick wrote: >> 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." > > Believe the manual. > >> >> 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? > > It's true. > Yes, you can use mediumtext. > > More precisely, you can use: CHAR and VARCHAR, if they're not declared > as BINARY, and any of the TEXT types. > > You cannot use binary string columns. > >> >> Is there a way to convert a column from one to the other? > > Yes: > > ALTER TABLE tbl_name MODIFY col_name MEDIUMTEXT; > >> >> 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