Forum Moderators: coopster

Message Too Old, No Replies

mysql howto: multibyte fulltext index?

anything alternative method, while it's only in mysql todo list?

         

Xuefer

3:39 am on Aug 30, 2003 (gmt 0)

10+ Year Member



it's very slow to do a LIKE "%...%"

bilalak

5:50 am on Aug 30, 2003 (gmt 0)

10+ Year Member



Try using MATCH AGAINST. It is a bit faster but gives wrong results with 2 bytes ( I tried with Arabic and it mixes letters)

Have a look at this URL
[mysql.com...]

Xuefer

6:42 am on Aug 30, 2003 (gmt 0)

10+ Year Member



it will only works on English-like language, which it's words separated by space
not for Chinese language "ThisIsATest"

bilalak

7:10 am on Aug 30, 2003 (gmt 0)

10+ Year Member



Dear Xusfer
it is not only the limiters. For Arabic Language it mixes between letters also. I do not know why and I post a note on mysql about it long ago
It might need local developers to take care of this.

Xuefer

5:13 am on Aug 31, 2003 (gmt 0)

10+ Year Member



anyone experienced using lucene with php?