MySQL Collation – Encoding

  • philaweb

    (@philaweb)


    19 years ago

    Some time ago I migrated some WordPress installations from a webhost to my own web server. For some reason, the non-English installations had some encoding problems after the migration. I have looked as to what can be the difference from the old MySQL database to the new, to my surprise it seems the old MySQL database did not have any “collation” settings.

    So, my question now is how the new MySQL database determined what collation to use? It automatically assumed “latin1_swedish_ci”, but perhaps that is the default setting of MySQL since the database is a Swedish developed database?

    What is the correct collation settings for WordPress and how do I adjust the MySQL settings?

  • The topic ‘MySQL Collation – Encoding’ is closed to new replies.