data types: TEXT, MEDIUMTEXT, LONGTEXT

2004-02-27 Thread Louis Hinman
I see the data types TEXT MEDIUMTEXT LONGTEXT listed in the MySQL documentation, and I have read Section 13.7 MySQL Full-Text Search. I infer from this that it is possible to store searchable text files in tables. My questions are these: * Is the procedure to store file

Re: data types: TEXT, MEDIUMTEXT, LONGTEXT

2004-02-27 Thread Sasha Pachev
* Is the procedure to store file paths, or the actual text itself? In order to use MySQL full-text indexing funcionality, you will need to store the actual text, and you need to have a FULLTEXT index on the column. Note that full-text indexing is supported only with MyISAM tables. *