Brion Vibber wrote:
My preference, if possible, would be to get MySQL to fix their Unicode support to allow for either storage of full UTF-8 or proper transformation of UTF-8 to UTF-16. UCS-2 collation with UTF-16 conversion semantics would be "good enough" for us, I think, and avoids the 4-byte-per-character index bloat of extending the UTF-8 support.
Bug filed: http://bugs.mysql.com/bug.php?id=14052
-- brion vibber (brion @ pobox.com)