3 ms·
I wonder if anyone else has the experience of complaining about and pointing this problem out for a decade or more before emojis become widespread, and pretty m
by avar 8y ago
I wonder if anyone else has the experience of complaining about and pointing this problem out for a decade or more before emojis become widespread, and pretty much nobody cared ("they speak what language?"). But as soon as emojis became more widespread suddenly proper Unicode support became everyone's problem.
- pkulak 8y agoPretty smart to put the fun stuff at the end so that everyone has to worry about everything in the middle.
- bdamm 8y agoThere must be a name for this approach to software design. That is, creating a forcing function that must correctly handle the popular case which by proxy handles a majority of less common but still important cases. (I'm aghast that MySQL had this issue!)
- marcodave 8y agoit might be called ️-dd (aka emoji-driven-design)
- devy 8y agoThere are tons of unicode characters that are outside of BMP that MySQL's original 3-byte implementation didn't support. [1] It just happened that emojis have been becoming wider spread than those non-BMP unicode characters. [1]: https://stackoverflow.com/questions/5567249/what-are-the-most-common-non-bmp-unicode-characters-in-actual-use https://stackoverflow.com/questions/5567249/what-are-the-mos...