Re: fulltext max size

2005-08-24 Thread SGreen
Yui Hiroaki <[EMAIL PROTECTED]> wrote on 08/24/2005 12:38:18 PM: > 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"

Re: fulltext max size

2005-08-24 Thread Yui Hiroaki
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

Re: fulltext max size

2005-08-24 Thread Alec . Cawley
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 (4); > > > But title is so small to insert text. > what biggest text I can insert tit

fulltext max size

2005-08-24 Thread Yui Hiroaki
I created table for fulltext. I publish SQL: sql>create table (test title longtext)TYPE=MyISAM; sql>alter table test add fulltext title (4); 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)