In MySQL, don’t use “utf8”, use “utf8mb4” (2016)
Possibly my favourite thing about the rise of emoji is that they’re not Basic Multilingual Plane, and so stupid hacks like MySQL’s utf8 character set (I seriously don’t know why anyone ever thought it was a good idea in 2002–2004) are now <i>obviously</i> insufficient for full Unicode support, and enough people <i>care</i> about them that adoption of this basic level of Unicode is driven, and so non-English speakers are inadvertently helped.<p>The next hurdle is to convince people that extended grapheme clusters are the smallest divisible unit, and that just like slicing at the byte level is insufficient if you’re doing UTF-8, slicing at the code point level is insufficient. Basically, strings should just be treated as opaque data in almost all places.