Title: Character Encoding Issue
Last modified: August 18, 2016

---

# Character Encoding Issue

 *  [oh_hello](https://wordpress.org/support/users/oh_hello/)
 * (@oh_hello)
 * [19 years, 5 months ago](https://wordpress.org/support/topic/character-encoding-issue/)
 * Hi Folks,
 * I’m trying to move my site from one server to another. It’s clear that I’m having
   a problem with my Character Encoding, but I just can’t seem to find a solution.
 * I’ve tried adding a line of code to wp-db.php as per [ his post](http://wordpress.org/support/topic/55282?replies=10#post-303707),
   but unfortunately it didn’t work for me.
 * My situation:
 * The site I’m trying to transfer [lives here](http://inertiawebdesign.com/hc/wordpress/)
   and I’m trying to transfer it here: [http://66.246.183.4/~horsecan/](http://66.246.183.4/~horsecan/).
 * You will see in the posts on the destination site what exactly is happening with
   the Encoding.
 * I’m exporting my database from MySQL4 and importing it to MySQL5, could this 
   be a problem?
 * After I downloaded my database, I made sure to open it in a text editor and save
   it as UTF-8, that doesn’t seem to be making a difference.
 * Any ideas as to how I could solve this problem?
 * Thanks in advance.

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

 *  [moshu](https://wordpress.org/support/users/moshu/)
 * (@moshu)
 * [19 years, 5 months ago](https://wordpress.org/support/topic/character-encoding-issue/#post-490616)
 * The different versions of MySQL could be a problem.
 * But make sure you check that not only the encoding (utf-8) is the same for the
   old and new database, but also the collation is the same!
 * And finally, why are you opening the .sql file?
 *  [Samuel B](https://wordpress.org/support/users/samboll/)
 * (@samboll)
 * [19 years, 5 months ago](https://wordpress.org/support/topic/character-encoding-issue/#post-490622)
 * MySQL5 can be a definite problem. Can you roll back to 4 and check it? I’ve had
   to do this many times on installs.
 * edit – You may need to just wait until your domain name resolves.
 *  Thread Starter [oh_hello](https://wordpress.org/support/users/oh_hello/)
 * (@oh_hello)
 * [19 years, 5 months ago](https://wordpress.org/support/topic/character-encoding-issue/#post-490637)
 * I was opening the .sql file so I could switch all instances of my old domain.
   I’ll have to check with my host to see if we can roll back to 4.
 * Also, something I just realized I forgot to mention…
 * I’m creating the backup through the WordPress Database Backup plugin, because
   when I try the export through phpMyAdmin, it doesn’t export all my posts. I’m
   left with about a 60% export, everytime. Could this be related to the problem?
 *  Thread Starter [oh_hello](https://wordpress.org/support/users/oh_hello/)
 * (@oh_hello)
 * [19 years, 5 months ago](https://wordpress.org/support/topic/character-encoding-issue/#post-491001)
 * **Update:** I was talking to my webhost, and they can’t roll it back to MySQL4.
   They even took a shot at transferring the database for me, but didn’t have any
   luck.
 * Are there any other ideas that may work?
 * I appreciate the help so far, thanks.

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

The topic ‘Character Encoding Issue’ is closed to new replies.

## Tags

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

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 4 replies
 * 3 participants
 * Last reply from: [oh_hello](https://wordpress.org/support/users/oh_hello/)
 * Last activity: [19 years, 5 months ago](https://wordpress.org/support/topic/character-encoding-issue/#post-491001)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics