Quote:
Originally Posted by Lynne
Did you still have access to the old server so you can try an export/import again?
|
No.
Quote:
Originally Posted by Lynne
Are you using vBulletin Search or Fulltext search?
|
vBulletin
Quote:
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?