4 ms·
Without diving too far into technical details, suffice it to say that in order to support the special characters that some languages require to be complete, we
by tedunangst 14y ago
Without diving too far into technical details, suffice it to say that in order to support the special characters that some languages require to be complete, we needed to do an upgrade of the database server software.
Oh, hi, I see you're using MySQL. MySQL's 1024 character (oh sorry, not characters, bytes, oopsie!) limit for indices was the bane of my existence. You have a mountain of code and tables using varchar(200) and an index spanning five such columns. Works with latin-1. Then somebody decides this new fangled utf-8 is the new hotness. hahahaha, no database index for you! Now you get to go back and decide if you can shrink said columns or get by with a one column index (mysql assumes 3 bytes, so one 200 char column is already more than half your allotment).
- seiji 14y agoThe hilarious part is this is just Catastrophic MySQL Production Error Case #693, but people won't dare move away from MySQL. They will keep using it and building out new services based on it because there's such a large list of known failure cases. People feel safe knowing how things can fail rather than seeing something "just work" and not knowing why.
- Maxious 14y agoWhy do you need to do a MySQL upgrade you say? "Up until MySQL 5.5 (released December of 2010) the UTF-8 support was severely hobbled." [missing some Japanese characters, including those used in many people's names, and accents] http://mzsanford.wordpress.com/2010/12/28/mysql-and-unicode/ http://mzsanford.wordpress.com/2010/12/28/mysql-and-unicode/
- unwind 14y agoOn a different but related note, I found that sentence to be pretty ... strange. They go into lots of technical detail about servers, indices, users and tables and things, but that wording sounds as if they're explaining the world to a (small) child. The idea that there are "normal" (=US ASCII, I presume?) and "special" (=the rest) characters used in human languages is a bit 1980:s, or thereabouts, to me.
- gadders 14y agoI'm guessing the primary audience is the site's users - i.e. people macrame-ing plant holders and such like - and not other techies.