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
utf8 character set can be
used, but not the
ucs2 character set.
FULLTEXT indexes on
ucs2 columns cannot be used, you can
IN BOOLEAN MODE searches on a
ucs2 column that has no such index.
Ideographic languages such as Chinese and Japanese do not
have word delimiters. Therefore, the
FULLTEXT parser cannot
determine where words begin and end in these and other such
languages. The implications of this and some
workarounds for the problem are described in
Section 11.9, “Full-Text Search Functions”.
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 use the same
character set and collation.
MATCH() column list must
match exactly the column list in some
FULLTEXT index definition for the table,
IN BOOLEAN MODE. Boolean-mode searches
can be done on nonindexed columns, although they are likely
to be slow.
The argument to
AGAINST() must be a
Index hints do not work for