(mysql.info.gz) Fulltext Restrictions

Info Catalog

(mysql.info.gz) Fulltext Query Expansion

(mysql.info.gz) Fulltext Search

(mysql.info.gz) Fulltext Fine-tuning

 
 12.6.3 Full-Text Restrictions
 -----------------------------
 
    * Full-text searches are supported for `MyISAM' tables only.
 
    * As of MySQL 4.1.1, full-text searches can be used with most
      multi-byte character sets. The exception is that for Unicode, the
      `utf8' character set can be used, but not the `ucs2' character set.
 
    * As of MySQL 4.1, the use of multiple character sets within a
      single table is supported. However, all columns in a `FULLTEXT'
      index must have the same character set and collation.
 
    * The `MATCH()' column list must exactly match the column list in
      some `FULLTEXT' index definition for the table, unless this
      `MATCH()' is `IN BOOLEAN MODE'.
 
    * The argument to `AGAINST()' must be a constant string.
 

Info Catalog

(mysql.info.gz) Fulltext Query Expansion

(mysql.info.gz) Fulltext Search

(mysql.info.gz) Fulltext Fine-tuning