首批通过分布式安全可靠测评，为关键业务系统打造
information_schema.CHARACTER_SETS
更新时间：2026-07-15 20:42:47
编辑
分享
说明
该视图从 V1.4 版本开始引入。
功能描述
展示 OceanBase 数据库的字符集信息。
字段说明
| 字段名称 | 类型 | 是否可以为 NULL | 描述 |
|---|---|---|---|
| CHARACTER_SET_NAME | varchar(128) | NO | 字符集名称 |
| DEFAULT_COLLATE_NAME | varchar(128) | NO | 字符集比对方法 |
| DESCRIPTION | varchar(64) | NO | 字符集描述 |
| MAXLEN | bigint(20) | NO | 字符集最大长度 |
查询示例
查看 OceanBase 数据库的字符集信息。
obclient [oceanbase]> SELECT * FROM information_schema.CHARACTER_SETS;
查询结果如下：
+--------------------+-------------------------+-----------------------+--------+
| CHARACTER_SET_NAME | DEFAULT_COLLATE_NAME | DESCRIPTION | MAXLEN |
+--------------------+-------------------------+-----------------------+--------+
| binary | binary | Binary pseudo charset | 1 |
| utf8mb4 | utf8mb4_general_ci | UTF-8 Unicode | 4 |
| gbk | gbk_chinese_ci | GBK charset | 2 |
| utf16 | utf16_general_ci | UTF-16 Unicode | 4 |
| gb18030 | gb18030_chinese_ci | GB18030 charset | 4 |
| latin1 | latin1_swedish_ci | cp1252 West European | 1 |
| gb18030_2022 | gb18030_2022_chinese_ci | GB18030-2022 charset | 4 |
| ascii | ascii_general_ci | US ASCII | 1 |
| tis620 | tis620_thai_ci | TIS620 Thai | 1 |
| utf16le | utf16le_general_ci | UTF-16LE Unicode | 4 |
| sjis | sjis_japanese_ci | SJIS | 2 |
| big5 | big5_chinese_ci | BIG5 | 2 |
| hkscs | hkscs_bin | HKSCS | 2 |
| hkscs31 | hkscs31_bin | HKSCS-ISO UNICODE 31 | 2 |
| dec8 | dec8_swedish_ci | DEC West European | 1 |
+--------------------+-------------------------+-----------------------+--------+
15 rows in set
