Full-text search doesn't work for multi-byte languages

[deminy]

When a user use East Asian words as keywords to search entries, he will get no result since MySQL's full-text search doesn't work for multi-byte languages (like Chinese, Japanese, etc).

I think it's better to provide a switch to switch between full-text search and like-statement search, which means the following two functions need to be updated:

1. function "serendipity_searchEntries" in file "include/functions_entries.inc.php"; and

2. function "serendipity_drawList" in file "include/admin/entries.inc.php"

BTW, there is a minor bug in function "serendipity_drawList". Function "serendipity_searchEntries" works for PostgreSQL, SQLite and MySQL, while function "serendipity_drawList" only works for MySQL (if user wants to search "body" information).

[garvinhicking]

Hi!

Hm, but the LIKE search is terribly slow. I figure a better solution would be to make MySQL support multibyte languages.

Adding a config option to toggle the use should not be that hard, because I think there already is a code brnach that uses LIKE if pgsql or sqlite is used...

Regards,
Garvin

[xzilla]

Maybe the better solution is to just switch to postgres and use tsearch2, which can do multibyte free text search.