Collation类型

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

PolarDB-X支持下表所列的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