A character set is a combination of a set of symbols and encoding methods. A collation is the rules for sorting characters in a character set. This topic summarizes the collation types that PolarDB-X 1.0 supports.
Note 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 |