Comment by teknopaul
6 years ago
Techies at theregister.co.uk told me mysql cant persist some types of utf8 chars in their forums. Its not deliberate but common emojis dont work there too. Anyone know if HN uses mysql?
6 years ago
Techies at theregister.co.uk told me mysql cant persist some types of utf8 chars in their forums. Its not deliberate but common emojis dont work there too. Anyone know if HN uses mysql?
News, the software behind HN, doesn't, no. The filter for emojis is deliberate.
MySQL has multiple Unicode character sets. The one named "utf8" doesn't support all of utf8, but utf8mb4 supports it all.
mysql `utf8` is only 3 byte -- you have to specify something different that `utf8` to get full utf8 https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-sets...
I can attest MySQL 8.0 eats up emoji characters with no fuss.
HN doesn't even use a database.