FULLTEXT KEY in XOOPS (correction)

Date 2006-07-16 17:52:37 | Category: XOOPS
in englishin japanese

MySQL does not support "splitting words" for multibyte language.
And I've just found MySQL does not support "specifying text for search" in multibyte language.

This means that the feature of MySQL's fulltext search has non-sense for multi-byte users.

Even for single byte users, this feature is not so useful than "LIKE", though FULLTEXT KEY makes updates of indexes slower.

If you are a developer of XOOPS modules, you'd better remove FULLTEXT KEY from your sql/mysql.sql.


You can read more news at PEAK XOOPS.
http://xoops.peak.ne.jp

The URL for this story is:
http://xoops.peak.ne.jp/md/news/index.php?page=article&storyid=139