PEAK XOOPS - FULLTEXT KEY in XOOPS (correction) in englishin japanese

Archive | RSS |
XOOPS
XOOPS : FULLTEXT KEY in XOOPS (correction)
Poster : GIJOE on 2006-07-16 17:52:37 (6554 reads)

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.

0 comments

Related articles
Printer friendly page Send this story to a friend

Comments list

Login
Username or e-mail:

Password:

Remember Me

Lost Password?

Register now!