A character set is a combination of a set of symbols and encoding methods. A collation is the group of rules for sorting characters in a character set. This topic describes the collation types supported by PolarDB-X.
PolarDB-X supports the collation types that are listed in the following table. For more information about the collation types, see Collations.
Character set | collation |
---|---|
utf8 | utf8_general_ci |
utf8_bin | |
utf8_unicode_ci | |
utf8mb4 | utf8mb4_general_ci |
utf8mb4_bin | |
utf8mb4_unicode_ci | |
utf16 | utf16_general_ci |
utf16_bin | |
utf16_unicode_ci | |
ascii | ascii_general_ci |
ascii_bin | |
binary | binary |
latin1 | latin1_swedish_ci |
latin1_german1_ci | |
latin1_danish_ci | |
latin1_bin | |
latin1_general_ci | |
latin1_general_cs | |
latin1_spanish_ci | |
gbk | gbk_chinese_ci |
gbk_bin |