Note
This view is introduced since OceanBase Database V1.4.
Purpose
This view displays information about character sets of OceanBase Database.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| CHARACTER_SET_NAME | varchar(128) | NO | The name of the character set. |
| DEFAULT_COLLATE_NAME | varchar(128) | NO | The name of the collation. |
| DESCRIPTION | varchar(64) | NO | The description of the character set. |
| MAXLEN | bigint(20) | NO | The maximum length of the character set. |
Sample query
Query information about character sets of OceanBase Database.
obclient [oceanbase]> SELECT * FROM information_schema.CHARACTER_SETS;
The query result is as follows:
+--------------------+-------------------------+-----------------------+--------+
| 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