Wrong encoding between ipb3 and sphinx

Question

Sphinx

Good day to all.

I recently set up sphinx on a VPS for a forum, after some problems sphinx successfully earned. However, after linking it with ipb, one problem emerged. When searching, only queries in Latin are correctly displayed. The reason I installed is ipb sends request in cp1251 and sphinx receives in utf-8. However, I did not find a way to solve this problem. Who faced, tell me how to be?

Answer 1

In the config that generates IPB, you need to add the line before each sql_query_pre

Answer 2

In sphinx, you need to set encodings in the config
in the source, depending on the encoding
sql_query_pre = SET NAMES utf8
or
sql_query_pre = SET NAMES cp1251
in the index, depending on the encoding
charset_type = utf-8
or
charset_type = sbcs
And the sphinx with such parameters can search for sites with utf8 or cp1251 encodings

Answer 3

Maybe I'm doing something wrong, but the last tips did not help me. Here is the config zalil.ru/31952225 Maybe I'm not specifying correctly. If anyone can, throw off your worker.

Answer 4

Hello again everyone.
I partly coped with that problem, but something remained: the index and the launch of the daemon go without errors, however, when I want to search for something on the forum with a request in Cyrillic, it tells me that there is nothing, the Latin search works everywhere, plus the Cyrillic search does not work only by post. Everything works in blogs, galleries and calendar. With what it can be connected.
My config: zalil.ru/31974004

Answer 5

motomac
the problem is relevant for me, can I get a hint?