Tim Starling wrote:
MySQL 5.0 does not reject the surrogate characters
between U+D800 and
U+DFFF. This means we can store characters above the BMP either by setting
the character set to UTF-8 and inserting CESU-8, or by setting the character
set to UCS-2 and inserting UTF-16.
Sorry, I didn't realise that this subject has already been discussed on this
list:
http://mail.wikipedia.org/pipermail/wikitech-l/2005-October/031977.html
Except Brion called it pseudo-UTF-8 instead of CESU-8.
-- Tim Starling