What's not to love about sphinx?

Question

Sphinx

I'm trying to do a search through "OR" in MATCH. Match gets possible misspellings of the word.
We are looking for 'test search' after running through the possible options. The request looks like this. way

select id, weight() from default where MATCH('test search | еуые ыуфкср | тест сеарч | tеst sеаrсh');

I get an error

index default: syntax error, unexpected '|' near ' еуые ыуфкср | тест сеарч | tеst sеаrсh'

What does he not like? Moreover, if you remove "euye yufksr", then it works, but returns an empty result, although "test search" is definitely in the indexed data.

Answer 1

Check encoding. Must be UTF-8 both in the text and when connecting.