Documentation Home
MySQL 5.7 Reference Manual
Related Documentation Download this Manual Excerpts from this Manual 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: A collation name such as utf8_unicode_520_ci is based on UCA 5.2.0 weight keys:

Download this Manual
User Comments
Sign Up Login You must be logged in to post a comment.