The MU forums have moved to WordPress.org

Encoding problem after moving site (10 posts)

  1. turkel
    Member
    Posted 14 years ago #

    Hi,

    I got encoding problem after moving site to another server. Everything seems OK, but i can`t read Azerbaijani umlauts. Domain: http://vsayt.com
    MySQL connection collation:
    MySQL charset: UTF-8 Unicode (utf8)
    Please help, how can i solve this problem?

  2. turkel
    Member
    Posted 14 years ago #

    Please help me, i am in trouble :(

  3. SteveAtty
    Member
    Posted 14 years ago #

    If your charsets are not the same on the two databases then you'll need to use options on the import to change things.

    Lots of documentation here:

    http://dev.mysql.com/doc/refman/5.0/en/charset-connection.html

  4. turkel
    Member
    Posted 14 years ago #

    Thanks for reply, my connection with database is also UTF8
    MySQL connection collation: utf8_general_ci
    MySQL charset: UTF-8 Unicode (utf8)
    Databases are all UTF8

    Is there are anything other solution for that, please help :(

  5. turkel
    Member
    Posted 14 years ago #

    I have found some server configuration:

    Character set client: latin1
    Character set connection: latin1
    Character set database: latin1
    Character set results: latin1
    Character set server: latin1
    Character set system: utf8
    collation connection: latin_swedish_ci
    collation database: latin_swedish_ci
    collation server: latin_swedish_ci

    I can`t change this variables but i can request it from server administrator, so tell me which of them causes the problem?
    Please help me, i am trouble.

  6. andrea_r
    Moderator
    Posted 14 years ago #

    "Databases are all UTF8"

    Then all the character sets listed above shoudl be the same. in other words, wherever it says latin anything, it needs to say UTF8.

  7. turkel
    Member
    Posted 14 years ago #

    I can`t change these server configuration as i am on shared server and server admins also say these are default settings. Bu on my previous server these setting was same, i am sure. Is there is any other factor may cause the problem ?

  8. turkel
    Member
    Posted 14 years ago #

    Database connection is OK as i can save new posts, but old posts have error. Something wrong on database, but i also see my umlauts from my database, may be script configured incorrectly?

  9. andrea_r
    Moderator
    Posted 14 years ago #

  10. turkel
    Member
    Posted 14 years ago #

    Yeah, i have tried them with all variable combinations, but not helped. I also have Multi DB, but as you know this plugin uses default settings. Everything on frontpage is edited and converted into my language format manually and it seems works OK, but there are 368 blogs on my site and what to do with them ?
    I have tried to convert database to UTF8 but not help yet as my database also UTF8 :(

About this Topic