Hi,
On Tue, Jun 8, 2010 at 2:35 AM, Aryeh Gregor
<Simetrical+wikilist(a)gmail.com> wrote:
Yes, but the binary encoding doesn't use
MySQL's UTF-8 support. It
stores the UTF-8 as binary data, so it can store non-BMP characters
even though MySQL's utf8 encoding can't. MySQL 5.5 is planned to add
a utf8mb4 encoding that will support all of Unicode.
I have modified the script by Brion which now include varchar binary,
in additional to varbinary
original:
http://bugs.mysql.com/bug.php?id=14052
new:
http://pastebin.com/MxitPssH
obviously, varchar(255) binary does not support character outside of BMP.