字符集(Character Set)是一组字符符号及编码方式的组合,collation是建立在某一字符集上的字符排序规则。本文汇总了PolarDB-X支持的collation类型。

说明 PolarDB-X 1.0PolarDB-X 2.0均支持下表所列的collation类型。关于collation类型的详细信息,请参见Collations
字符集 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