Collation Names
MySQL collation names follow these rules:
- A name ending in
_ci
indicates a case-insensitive collation. - A name ending in
_cs
indicates a case-sensitive collation. - A name ending in
_bin
indicates a binary collation. Character comparisons are based on character binary code values. - Unicode collation names may include a version number to indicate the version of the Unicode Collation Algorithm (UCA) on which the collation is based. UCA-based collations without a version number in the name use the version-4.0.0 UCA weight keys: http://www.unicode.org/Public/UCA/4.0.0/allkeys-4.0.0.txt. A collation name such as
utf8_unicode_520_ci
is based on UCA 5.2.0 weight keys: http://www.unicode.org/Public/UCA/5.2.0/allkeys.txt.