Thank you for your reply.
> sql>create table (test title longtext)TYPE=MyISAM;
> sql>alter table test add fulltext (title);
Your SQL above does not define the word long. How much
character can I insert into "title" column?
Yui
What do you expedt the number in brackets to do? I cannot find any
documentation on it, but if anything I would expect it to be maximum
length of a single word in the indexed column. You surely cannot expect to
get a word 4294967295 characters long. Indeed, if you expect a word 40000
characters long, I think you are using the wrong tool.
I think your coad should read:
sql>create table (test title longtext)TYPE=MyISAM;
sql>alter table test add fulltext (title);
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
