1

I searched, and all I find is descriptions of the names, and the selection of collations.

For example:

_Zulu
0Alpha
Alpha
alpha

usually sorts this way (on US Windows, most SQL servers etc.), underscore first. This is done, of course, according to the configured collation. This collation has a name, but that's not what I want to know.

What I want to know, is: what IS the collation? How is it actually made up?

Something like:

_
0
1
2
3
4
...
a
...
A
...
Z
0
3

The collations (at least for Unicode) are based on the following specificatons:

http://www.unicode.org/cldr/charts/30/collation/index.html

0

The ordering of letters in various MySQL COLLATIONs is given here for utf8 and here for utf8mb4.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.