4 ms·
To clarify: the 3-byte subset is not a MySQL invention. It is the Basic Multilingual Plane (BMP): http://en.wikipedia.org/wiki/Plane_%28Unicode%29#Basic_Multil
by morgo 12y ago
To clarify: the 3-byte subset is not a MySQL invention. It is the Basic Multilingual Plane (BMP): http://en.wikipedia.org/wiki/Plane_%28Unicode%29#Basic_Multilingual_Plane http://en.wikipedia.org/wiki/Plane_%28Unicode%29#Basic_Multi...
- Zr40 12y agoThat's not correct. The Basic Multilingual Plane (like Unicode itself) is not an encoding, it is a subset of the Unicode codespace. UTF-8 restricted to sequences of 3 bytes can only represent characters between U+0000 and U+FFFF inclusive, which happens to exactly contain the characters defined by the BMP.
- sly010 12y agoMost smileys now ubiquitous on smart phone keyboards are valid Unicode characters outside of the BMP set, yet being used constantly on the web. BMP just doesn't make sense anymore, nor does mysql utf8.
- morgo 12y agoI totally agree! It also makes sense for countries that have their own character sets to use utf8 too (as they may borrow words, characters from other languages). I was just pointing out that even if it was limited support, it wasn't a set of characters that MySQL came up with.
- deleted 12y ago[deleted]