Friday, 9 August 2013

Sphinx exact match error

Sphinx exact match error

We have website that uses this query:
SELECT did, kid FROM top_keywords WHERE MATCH('@keyword "^EXAMPLE
KEYWORD$"') LIMIT 0,
100;
It works great in 99% times, but with some encoding it doesn't work. Example:
SELECT did, kid FROM top_keywords WHERE MATCH('@keyword "^åñãïí$"') LIMIT
0, 100;
Produces error:
ERROR 1064 (42000): index top_keywords: syntax error, unexpected '$',
expecting TOK_KEYWORD or TOK_INT near 'åñãïí$"'
My sphinx version is 2.0.6.
My only idea is that has something to do with conf-charset-type.

No comments:

Post a Comment