"Search term" in bbPress admin doesn't work for Cyrillic words

[SergeyBiryukov]

If you search for "плагин", "тема", "файл" (or any other Cyrillic word commonly used on forums) in bbPress admin on ru.forums.wordpress.org, you'll just get "No posts found".

If the topic has some English words (a plugin name, etc.), you may eventually succeed by searching for them and wading through a lot of unrelated topics, but most of the time you're out of luck.

Combined with #121 and #347, it's virtually impossible to find any topic older than a few days, even if you're an administrator and happen to remember the exact keywords.

[SergeyBiryukov]

Combined with #121 and #347, it's virtually impossible to find any topic older than a few days, even if you're an administrator and happen to remember the exact keywords.

Would it be possible to at least fix this one?

It does work on a clean bbPress 1.x install, so it's probably a latin1 DB issue, which makes me think it wouldn't be fixed with the upgrade to bbPress 2.x and needs to be fixed separately anyway.

[SergeyBiryukov]

Just spent another 10 minutes to find a topic that could be found in 10 seconds if the admin search worked.

[samuelsidler]

Tracking bug for upgrading to bbPress 2.x is #1544.

[ocean90]

@SergeyBiryukov Just did a search for "плагин" and it's working for me, see 276.png​. Do you use any filters?

[SergeyBiryukov]

Replying to ocean90:

@SergeyBiryukov Just did a search for "плагин" and it's working for me, see 276.png​. Do you use any filters?

Try searching for posts instead of topics (sorry if that was not clear from my description).

[ocean90]

bbPress is doing a full-text search by using MATCH() ... AGAINST if the length of the search term is over 5 ("пл" is using LIKE, "пла" MATCH), see ​BB_Query->generate_post_text_sql(). This seems not to work with Cyrillic chars in a database with latin1 charset.

[SergeyBiryukov]

After the upgrade to bbPress 2.x in #1544, the admin search appears to work as expected.