Professional web developer, proud 🇪🇺 European, currently living in 🇳🇱 Rotterdam, 🏳️🌈 gay / homoflex., 💞 non-monogamist, 🍑 naturist, 🗽 liberal, 🕊 pacifist️, ⚛ atheist️.
Putting emojis in your database should be a piece of cake, right? You’ve had enough trouble with encodings in your lifetime, and now that we have the blessing of UTF-8, you’re always so careful to use it everywhere, so you’d expect all the characters to just finally work out of the box, right?
Well, I did expect that. But I’ve recently realised I can only put some emojis (like “❤️”) in by blog posts. Most of them were just lost or replaced with “?” by MySQL... Oh, those damn encodings again!
But fortunately the solution is quite simple.