Title: Character Encoding problem when migrating
Last modified: August 18, 2016

---

# Character Encoding problem when migrating

 *  [proxi](https://wordpress.org/support/users/proxi/)
 * (@proxi)
 * [19 years, 8 months ago](https://wordpress.org/support/topic/character-encoding-problem-when-migrating/)
 * I’m trying to convert my wordpress 1.5.2 site into a 2.0.x site.
 * Since I do not want to break anything of what it already working fine, I created
   a new database. I then uploaded a backup .sql file of the original database.
 * In my wp 2.0, I go to wp-admin and I proceed to update the database. However,
   all my accented letters are now appearing wrong.
 * The two tables seem identical, except that the new tables created by the update
   process are in utf-8 whereas all the other tables are in latin1_swedish…
 * What’s the deal? How do I get the accents to work right?
 * Thaks.!
 * brem of [http://martinbreton.com](http://martinbreton.com)
 * (new site is at [http://martinbreton.com/nouveau-site/](http://martinbreton.com/nouveau-site/))

Viewing 6 replies - 1 through 6 (of 6 total)

 *  Thread Starter [proxi](https://wordpress.org/support/users/proxi/)
 * (@proxi)
 * [19 years, 8 months ago](https://wordpress.org/support/topic/character-encoding-problem-when-migrating/#post-457709)
 * I forgot to mention that when I publish new articles, the characters appear fine…
 *  [moshu](https://wordpress.org/support/users/moshu/)
 * (@moshu)
 * [19 years, 8 months ago](https://wordpress.org/support/topic/character-encoding-problem-when-migrating/#post-457712)
 * That’s a mysql problem/bug as far as I can remember. If the mysql versions and
   settings are not the same on the two servers… it always gets borked.
 * See if this helps:
    [http://wordpress.org/support/topic/55282?replies=10#post-303707](http://wordpress.org/support/topic/55282?replies=10#post-303707)
 *  Thread Starter [proxi](https://wordpress.org/support/users/proxi/)
 * (@proxi)
 * [19 years, 8 months ago](https://wordpress.org/support/topic/character-encoding-problem-when-migrating/#post-457715)
 * It’s the same server, just a different database.
 *  Thread Starter [proxi](https://wordpress.org/support/users/proxi/)
 * (@proxi)
 * [19 years, 8 months ago](https://wordpress.org/support/topic/character-encoding-problem-when-migrating/#post-457717)
 * I guess my question is: is it my backup that is bad or is it when I import it
   that I do it wrong? Or… 😛
 *  Thread Starter [proxi](https://wordpress.org/support/users/proxi/)
 * (@proxi)
 * [19 years, 8 months ago](https://wordpress.org/support/topic/character-encoding-problem-when-migrating/#post-457718)
 * I also tried inserting the line as it is suggested in the other thread, but it
   doesn’t seem to affect the posts already in the database.
 *  Thread Starter [proxi](https://wordpress.org/support/users/proxi/)
 * (@proxi)
 * [19 years, 8 months ago](https://wordpress.org/support/topic/character-encoding-problem-when-migrating/#post-457721)
 * I solved my problem by using the database backup plugin. It seems like my phpMyAdmin
   backup is faulty… w e i r d. weird.

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘Character Encoding problem when migrating’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 6 replies
 * 2 participants
 * Last reply from: [proxi](https://wordpress.org/support/users/proxi/)
 * Last activity: [19 years, 8 months ago](https://wordpress.org/support/topic/character-encoding-problem-when-migrating/#post-457721)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics