字符集(Character Set)是一组字符符号及编码方式的组合,collation是建立在某一字符集上的字符排序规则。本文汇总了PolarDB-X 1.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 |