Title: MySQL Collation – Encoding
Last modified: August 18, 2016

---

# MySQL Collation – Encoding

 *  [philaweb](https://wordpress.org/support/users/philaweb/)
 * (@philaweb)
 * [20 years, 6 months ago](https://wordpress.org/support/topic/mysql-collation-encoding/)
 * 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.

## Tags

 * [collation](https://wordpress.org/support/topic-tag/collation/)
 * [encoding](https://wordpress.org/support/topic-tag/encoding/)
 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 0 replies
 * 1 participant
 * Last reply from: [philaweb](https://wordpress.org/support/users/philaweb/)
 * Last activity: [20 years, 6 months ago](https://wordpress.org/support/topic/mysql-collation-encoding/)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics