fulltext max size
I created table for fulltext. I publish SQL: sqlcreate table (test title longtext)TYPE=MyISAM; sqlalter 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); I got a error??? Regards, Yui -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: fulltext max size
Yui Hiroaki [EMAIL PROTECTED] wrote on 24/08/2005 10:57:20: I created table for fulltext. I publish SQL: sqlcreate table (test title longtext)TYPE=MyISAM; sqlalter 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); 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 4 characters long, I think you are using the wrong tool. I think your coad should read: sqlcreate table (test title longtext)TYPE=MyISAM; sqlalter 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]
Re: fulltext max size
Thank you for your reply. sqlcreate table (test title longtext)TYPE=MyISAM; sqlalter 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 4 characters long, I think you are using the wrong tool. I think your coad should read: sqlcreate table (test title longtext)TYPE=MyISAM; sqlalter 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]
Re: fulltext max size
Yui Hiroaki [EMAIL PROTECTED] wrote on 08/24/2005 12:38:18 PM: Thank you for your reply. sqlcreate table (test title longtext)TYPE=MyISAM; sqlalter 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 4 characters long, I think you are using the wrong tool. I think your coad should read: sqlcreate table (test title longtext)TYPE=MyISAM; sqlalter table test add fulltext (title); Alec First, your CREATE TABLE statement is not formed correctly. I assume that you want a MyISAM table called 'test' with only one column in it called 'title' than can be used as the target of a full text search. http://dev.mysql.com/doc/mysql/en/create-table.html CREATE TABLE test ( title longtext , FULLTEXT (title) ) ENGINE=MyISAM; How much information can `title` hold? I refer you to http://dev.mysql.com/doc/mysql/en/storage-requirements.html. Look for the longtext column type (about half-way down the page). Shawn Green Database Administrator Unimin Corporation - Spruce Pine