Search engine problem

[sergarch]

Originally Posted by Lynne

Did you still have access to the old server so you can try an export/import again?

No.

Originally Posted by Lynne

Are you using vBulletin Search or Fulltext search?

vBulletin

Originally Posted by Lynne

If using vBulletin search, have you checked the word table and verified the field collation types within that table are utf8_general_ci ?

Every table on my DB is utf8_general_ci

I checked searchcore_text table within and have found that russian text going on abracadabra (?žб?‰ий Фо?€?ƒм instead of "Общий Форум") The source is in UTF-8, but decoding in CP1252!

I did query on my DB - SHOW VARIABLES LIKE "char%"; and received an answer:

Variable_name

Value

character_set_client utf8
character_set_connection utf8
character_set_database utf8
character_set_filesystem binary
character_set_results utf8
character_set_server latin1
character_set_system utf8
character_sets_dir /usr/share/mysql/charsets/

As noted, the character_set_server is latin1 instead of utf8. May be this is the main problem?