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" 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 > > > > > > > >
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
