About Wordpress, emojis, MySQL and latin1, utf8 and utf8mb4 character sets

Jan van den Berg
Jul 12 · 4 min read
Strange characters!
Emojis!

Problem 1: exporting and importing the database with the wrong character set

Problem 2: some emojis work, some don’t

There is a question mark instead of an emoji

Problem 3: but I used emojis before, in my latin1 Wordpress installation?!

Wait, what?! The URL has the correct emoji but the post title does not!?!
How the title and the post name (url) are stored

Jan van den Berg

Written by

https://j11g.com

Welcome to a place where words matter. On Medium, smart voices and original ideas take center stage - with no ads in sight. Watch
Follow all the topics you care about, and we’ll deliver the best stories for you to your homepage and inbox. Explore
Get unlimited access to the best stories on Medium — and support writers while you’re at it. Just $5/month. Upgrade