--- title: "information_schema.CHARACTER_SETS - OceanBase 数据库 V4.2.5 | OceanBase 文档中心" description: information_schema.CHARACTER_SETS 说明 该视图从 V1.4 版本开始引入。 功能描述 展示 OceanBase 数据库的字符集信息。 字段说明 字段名称 类型 是否可以为 NULL 描述 CHARACTER_SET_NAME varchar(128) NO 字符集名称 DEFAULT… --- 切换语言 - 中文站 - 简体中文 - International - English - 日本站 - 日本語 文档反馈![](https://mdn.alipayobjects.com/huamei_22khvb/afts/img/A*P8CuR4UJ_FkAAAAAAAAAAAAADiGDAQ/original) OceanBase 数据库分布式版 - V 4.2.5 LTS # information_schema.CHARACTER_SETS 更新时间：2026-07-15 20:42:47 [编辑](https://github.com/oceanbase/oceanbase-doc/edit/V4.2.5/zh-CN/700.reference/700.system-views/400.system-view-of-mysql-mode/200.dictionary-view-of-mysql-mode/300.information_schema-character_sets-of-mysql-mode.md) #### 说明 该视图从 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 数据库的字符集信息。 ```shell obclient [oceanbase]> SELECT * FROM information_schema.CHARACTER_SETS; ``` 查询结果如下： ```shell +--------------------+-------------------------+-----------------------+--------+ | 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 ``` 上一篇 下一篇 ![有帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*y6ocSqN8cqsAAAAAAAAAAAAAARQnAQ)![无帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*BG9IQJyLHF8AAAAAAAAAAAAAARQnAQ)![反馈](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*eTWdQKCRKHwAAAAAAAAAAAAAARQnAQ)[AI](https://www.oceanbase.com/obi) 咨询热线