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.
© 2013, Oracle Corporation and/or its affiliates
User Comments
Add your own comment.