MySQL Database Migration and Special Characters

May 7th, 2007 by Jerome Dahdah

database.gifIf you’re a web designer who works with CMS systems, you’ll find that from time to time you’re going to have to do a little database migration. I usually create websites on my local test server and later on migrate them to their online servers. What often happens to me is that all the special characters get mangled up on the new server. Quotes et al turn into the weirdest combinations (“it’s” -> “it’s”). I’m pretty certain a few of you are nodding your heads in acknowledgment right now. Well then, it’s your lucky day: Michael Chu has written an article explaining why that happens, what you can do to fix it, and how you can prevent it in the future.

One Response to “MySQL Database Migration and Special Characters”

  1. Bundesliga Blog says:

    I’m currently switching to a new server and found some “lost” characters ( german umlauts ). I hope this explanation will help. Thanks for this link.

For a full experience, you must agree to the use of cookies. For more information, see our Privacy Policy

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.