After I executed the command:
export LANG=en_US.UTF-8
mysql -h 0 -P 9306 will work fine for :
mysql> select * from excursion_core where match('kike');
more information: http://stackoverflow.com/a/31006875/1054800
On Tuesday, June 23, 2015 at 8:09:25 PM UTC+8, Dillon Peng wrote:
>
> For supporting Chinese or CJK, I used a including CJK characters
> <https://gist.github.com/edouard/277986>' charset_table in sphinx.conf,
> after indexing and starting searchd, I used a client mysql to connect it:
>
> mysql -h 0 -P 9306
>
> and I can query and get all records using the following command:
>
> mysql> select * from excursion_core;
>
>
> But if I append where match I get nothing:
>
> mysql> select * from excursion_core where match('kike');
> Empty set (0.00 sec)
>
> For verifying whether such a new charset_table impact this, I used the
> old sphinx.conf only for english and run the same command:
>
> mysql> select * from excursion_core where match('kike');
>
> I can get all the records matching the string 'kike'.
>
> I guess I should use a different string for CJK's charset, but I don't
> know what string I should use? Any advice will be welcome!
>
--
You received this message because you are subscribed to the Google Groups
"sphinx-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sphinx-users.
For more options, visit https://groups.google.com/d/optout.
