Jay,
Jay Pipes wrote:
Roy, Jim,
Regarding collations, Brian and I just chatted about this. Currently,
MySQL only supports a single byte to indicate the collation, which means
that only 256 collations are supported by MySQL. This is a problem,
since they've already run out of identifiers.
There are actually only 22 collations defined in MySQL 6.0. The IDs are
almost running out because 22 for utf8, another 22 for utf8mb3, ucs2,
utf16, utf32 each. Drizzle does not need that many IDs.
Brian thinks we can chop the number of supported collations down
significantly in drizzle, because many of them are charset-specific, and
can re-start the ordering from 0, meaning that the ABI would not need to
change. This is important as heikki has expressed thoughts that he's
not willing to update InnoDB to support a 2-byte collation identifier at
this point.
Changing to 2-byte collation ID requires file format change, which is
not worth it.
Thanks,
Calvin
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
