3 ms·
I've had very few issues making programs I've written unicode friendly, but then I gave up on MySQL about a decade ago. The only real issue is handling bad inp
by aidenn0 14y ago
I've had very few issues making programs I've written unicode friendly, but then I gave up on MySQL about a decade ago.
The only real issue is handling bad input, as you never get an error with decoding e.g. ISO-8859-1; for a lot of applications you need to handle potentially malicious input, so you can do it there, but even for trusted input, there is a lot of really-broken external programs that output "UTF-8" or "UTF-16" (scare quotes intentional).
I really think a lot of the problems with unicode is that a lot of languages/libraries try to handle it transparently, and that just doesn't work; encoding/decoding is part of dealing with external formats, and trying to do it transparently means that it will fail unexpectedly.