Re: some questions related to Unicode

[Peter Gulutzan]

1. Data is sorted according to the collation that you pick.
2. To see a list of supported collations, "show collation"
or "select * from information_schema.collations".
3. We don't distinguish "Unicode" from "English".
4. Collation depends on data, not on user. But you can change defaults.
5. "show create table" or "select ... from information_schema.columns ...".
6. English names take 4 bytes in latin1, 4 bytes in UTF8, 8 bytes in UCS2.

Peter Gulutzan
MySQL / Sun