GBase8s 支持的字符集和排序规则

GBase8s 服务器内部支持多个字符集。用SHOW CHARACTER SET语句可以列出可用的字符集：

sqlcli> SHOW CHARACTER SET;

±-------------±-------------------------------------±------------------------±-------------+

| Charset | Description | Default collation |Maxlen |

±------------±------------------------------------±----------------------------±------------+

| big5 | Big5 Traditional Chinese | big5_chinese_ci | 2 |

| dec8 | DEC West European | dec8_swedish_ci | 1 |

| cp850 | DOS West European | cp850_general_ci | 1 |

| hp8 | HP West European | hp8_english_ci | 1 |

| koi8r | KOI8-R Relcom Russian | koi8r_general_ci | 1 |

| latin1 | cp1252 West European | latin1_swedish_ci | 1 |

| latin2 | ISO 8859-2 Central European| latin2_general_ci | 1 |

| swe7 | 7bit Swedish | swe7_swedish_ci | 1 |

| ascii | US ASCII | ascii_general_ci | 1 |

| ujis | EUC-JP Japanese | ujis_japanese_ci | 3 |

| sjis | Shift-JIS Japanese | sjis_japanese_ci | 2 |

| hebrew | ISO 8859-8 Hebrew | hebrew_general_ci | 1 |

| tis620 | TIS620 Thai | tis620_thai_ci | 1 |

| euckr | EUC-KR Korean | euckr_korean_ci | 2 |

| koi8u | KOI8-U Ukrainian | koi8u_general_ci | 1 |

| gb2312 | GB2312 Simplified Chinese | gb2312_chinese_ci | 2 |

| greek | ISO 8859-7 Greek | greek_general_ci | 1 |

| cp1250 | Windows Central European | cp1250_general_ci | 1 |

| gbk | GBK Simplified Chinese | gbk_chinese_ci | 2 |

| latin5 | ISO 8859-9 Turkish | latin5_turkish_ci | 1 |

| armscii8 | ARMSCII-8 Armenian | armscii8_general_ci| 1 |

| UTF8 | UTF-8 Unicode | utf8_general_ci | 3 |

| ucs2 | UCS-2 Unicode | ucs2_general_ci | 2 |

| cp866 | DOS Russian | cp866_general_ci | 1 |

| keybcs2 | DOS Kamenicky Czech-Slovak | keybcs2_general_ci | 1 |

| macce | Mac Central European | macce_general_ci | 1 |

| macroman | Mac West European | macroman_general_ci| 1 |

| cp852 | DOS Central European | cp852_general_ci | 1 |

| latin7 | ISO 8859-13 Baltic | latin7_general_ci | 1 |

| cp1251 | Windows Cyrillic | cp1251_general_ci | 1 |

| cp1256 | Windows Arabic | cp1256_general_ci | 1 |

| cp1257 | Windows Baltic | cp1257_general_ci | 1 |

| binary | Binary pseudo charset | binary | 1 |

| geostd8 | GEOSTD8 Georgian | geostd8_general_ci | 1 |

| cp932 | SJIS for Windows Japanese | cp932_japanese_ci | 2 |

| eucjpms | UJIS for Windows Japanese | eucjpms_japanese_ci | 3 |

±--------------±------------------------------------------±--------------------------±------+

一个字符集通常至少有一个排序规则，可能还有多个排序规则。

用SHOW COLLATION语句可以列出一个字符集的排序规则。例如，要想

查看UTF8字符集的排序规则，使用下面的语句查找那些名字以UTF8开头的排序规则：

sqlcli> SHOW COLLATION
LIKE 'UTF8%';

±--------------------±--------±-----±--------±-----------±---------+

| Collation | Charset | Id | Default | Compiled | Sortlen |

±--------------------±--------±-----±---------±----------±---------+

| utf8_general_ci | utf8 | 33 | Yes | Yes | 1 |

| utf8_bin | utf8 | 83 | | Yes | 1 |

| utf8_unicode_ci | utf8 | 192 | | Yes | 8 |

|utf8_icelandic_ci | utf8 | 193 | | Yes | 8 |

| utf8_latvian_ci | utf8 | 194 | | Yes | 8|

| utf8_romanian_ci | utf8 | 195 | | Yes | 8 |

|utf8_slovenian_ci | utf8 | 196 | | Yes | 8 |

| utf8_polish_ci | utf8 | 197 | | Yes | 8|

| utf8_estonian_ci | utf8 | 198 | | Yes | 8|

| utf8_spanish_ci | utf8 | 199 | | Yes | 8|

| utf8_swedish_ci | utf8 | 200 | | Yes | 8|

| utf8_turkish_ci | utf8 | 201 | | Yes | 8|

| utf8_czech_ci | utf8 | 202 | | Yes | 8|

| utf8_danish_ci | utf8 | 203 | | Yes | 8|

| utf8_lithuanian_ci | utf8 | 204 | | Yes | 8|

| utf8_slovak_ci | utf8 | 205 | | Yes | 8|

| utf8_spanish2_ci | utf8 | 206 | | Yes | 8|

| utf8_roman_ci | utf8 | 207 | | Yes | 8|

| utf8_persian_ci | utf8 | 208 | | Yes | 8|

±----------------------±----------±----±---------±-----------±----------+

排序规则具有下面的这些特性：

• 两个不同的字符集不能有同样的排序规则；
• 每个字符集都有一个缺省的排序规则；
• 排序规则的名字有约定俗成：以相关的字符集名开始，通常包括一个语言名，以_ci (不区分大小写)， _cs (区分大小写)或者 _bin (二进制)结束。