Calvin Sun wrote: > 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.
Right. >> 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. Yep, agreed. _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
