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
