Yui Hiroaki <[EMAIL PROTECTED]> wrote on 24/08/2005 10:57:20: > I created table for fulltext. I publish SQL: > > sql>create table (test title longtext)TYPE=MyISAM; > sql>alter table test add fulltext title (40000); > > > But title is so small to insert text. > what biggest text I can insert title column? > > When I publish SQL: alter table test add fulltext title(4294967295); > I got a error???
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]
