Collation types
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 | utf8_bin |
| utf8 | utf8_unicode_ci |
| utf8mb4 | utf8mb4_general_ci |
| utf8mb4 | utf8mb4_bin |
| utf8mb4 | utf8mb4_unicode_ci |
| utf16 | utf16_general_ci |
| utf16 | utf16_bin |
| utf16 | utf16_unicode_ci |
| ascii | ascii_general_ci |
| ascii | ascii_bin |
| binary | binary |
| latin1 | latin1_swedish_ci |
| latin1 | latin1_german1_ci |
| latin1 | latin1_danish_ci |
| latin1 | latin1_bin |
| latin1 | latin1_general_ci |
| latin1 | latin1_general_cs |
| latin1 | latin1_spanish_ci |
| gbk | gbk_chinese_ci |
| gbk | gbk_bin |