CP1251 Problem

[Light78]

We encounter several problems, when using kayako with russian language, with small letter "sh" (hexadecimal char code d8 in cp1251 or "d1 88" in utf-8).
1. articles, containing that letter show almost correctly, except for that letter, which is displayed by 2 nonprintable characters.
2. typing single letter "sh" into search field and submitting search form results in the following error displayed at the top of page:

Invalid SQL: SELECT `kbarticleid` FROM `swkbarticles` WHERE subject LIKE '%ш%' LIMIT 50;
(Illegal mix of collations (utf8_general_ci,IMPLICIT) and (cp1251_general_ci,COERCIBLE) for operation 'like')
Invalid SQL: SELECT `kbarticleid` FROM `swkbarticledata` WHERE contents LIKE '%ш%' LIMIT 50;
(Illegal mix of collations (utf8_general_ci,IMPLICIT) and (cp1251_general_ci,COERCIBLE) for operation 'like')

please tell us, what actions should we take to make russian language work in kayako.
thank you

[Sheep]

try changing your collations in mysql to cp1251 (warning, this -might- get supportsuite to not work anymore so dont use it on production site) or change supportsuite code as to convert cp1251 charset to UTF8 one when inserting strings into database.

The first one should be the best option, but i really dont know what the result will be.

[maxout]

3.11.01, problem with letter 'sh' still exist.

"change supportsuite code as to convert cp1251 charset to UTF8 one when inserting strings into database."

how to do this? what should i add to code?