MySQL Fulltext Search

[rfontaine]

Hi,

I am thinking of adding mysql full text search to our website. The documentation says it works on the "text" datatype. Do they mean it will also work on the other text types such as "medium text"?

Thank you in advance

[jatar_k]

[dev.mysql.com...]

A full-text index in MySQL is an index of type FULLTEXT. FULLTEXT indexes are used with MyISAM tables only and can be created from CHAR, VARCHAR, or TEXT columns at CREATE TABLE time or added later with ALTER TABLE or CREATE INDEX.

[rfontaine]

Yes, I saw that documentation. However, it does not specifically state that "mediumtext" columns will work (it just says "text" columns) with a fulltext search - which was my question.

After testing, which I was trying to avoid having to do, it seems medium text columns do indeed work.