MySQL Database Migration and Special Characters
May 7th, 2007 by Jerome DahdahIf 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.
May 11th, 2007 at 2:10 pm
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.