If 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.