3 ms·
> fixing systems which treated UTF-16 as UCS-2 Or treated UTF8 as the nonsense that MySQL's utf8 is (it's 3-bytes utf8 aka only the BMP, and silently drops any
by masklinn 6y ago
> fixing systems which treated UTF-16 as UCS-2
Or treated UTF8 as the nonsense that MySQL's utf8 is (it's 3-bytes utf8 aka only the BMP, and silently drops anything from the first non-BMP codepoint).
- mfontani 6y agoIndeed. To ensure MySQL stores "real" UTF-8 one has to use "utf8mb4" instead of "utf8", which just rolls off the tongue and backwards (in)compatibility seems to be the reason why one can't just DWIM things backwards... "utf8mb4 or bust" it is, then!