Character sets and collations

The Oracle mode of OceanBase Database supports the following character sets:

• binary

• utf8mb4

  Note

  For smooth migration, OceanBase Database treats UTF8 as a synonym for UTF8MB4 in syntax.

• gbk

• utf16

• gb18030

• latin1

• gb18030_2022

• ascii

• tis620

• utf16le

• sjis

• hkscs

• hkscs31

• dec8

• big5

  Applicability

  OceanBase Connector/J does not support the utf8mb4_unicode_ci and utf16_unicode_ci collations.

The Oracle mode of OceanBase Database supports the following collations: | Character set | Collation | | :------------- | :------------- | | binary | BINARY |

| utf8mb4 | utf8mb4_bin, utf8mb4_unicode_ci, utf8mb4_0900_ai_ci, utf8mb4_0900_as_ci, utf8mb4_0900_ci_ai, utf8mb4_0900_ci_as, utf8mb4_0900_cs_ai, utf8mb4_0900_cs_as, utf8mb4_0900_cs_ci, utf8mb4_0900_cs, utf8mb4_0900_ks_ai_ci, utf8mb4_0900_ks_as_ci, utf8mb4_0900_ks_ci_ai, utf8mb4_0900_ks_ci_as, utf8mb4_0900_ks_cs_ai, utf8mb4_0900_ks_cs_as, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci, utf8mb4_0900_ks_cs, utf8mb4_0900_ks_cs_ci,

In Oracle mode of OceanBase Database, you can view the default collation of the nls_sort variable by querying the NLS_DATABASE_PARAMETERS system view. The nls_nchar_characterset variable corresponds to the default character set for NCHAR, NVARCHAR2, and NCLOB data types, and the nls_characterset variable corresponds to the default character set for CHAR, VARCHAR2, and CLOB data types.

obclient> SELECT * FROM NLS_DATABASE_PARAMETERS;
+-------------------------+------------------------------+
| PARAMETER               | VALUE                        |
+-------------------------+------------------------------+
| NLS_DATE_FORMAT         | DD-MON-RR                    |
| NLS_TIMESTAMP_FORMAT    | DD-MON-RR HH.MI.SSXFF AM     |
| NLS_TIMESTAMP_TZ_FORMAT | DD-MON-RR HH.MI.SSXFF AM TZR |
| NLS_TERRITORY           | AMERICA                      |
| NLS_SORT                | BINARY                       |
| NLS_COMP                | BINARY                       |
| NLS_CHARACTERSET        | AL32UTF8                     |
| NLS_NCHAR_CHARACTERSET  | AL16UTF16                    |
| NLS_DATE_LANGUAGE       | AMERICAN                     |
| NLS_LENGTH_SEMANTICS    | BYTE                         |
| NLS_NCHAR_CONV_EXCP     | FALSE                        |
| NLS_CALENDAR            | GREGORIAN                    |
| NLS_NUMERIC_CHARACTERS  | .,                           |
| NLS_CURRENCY            | $                            |
| NLS_ISO_CURRENCY        | AMERICA                      |
| NLS_DUAL_CURRENCY       | $                            |
+-------------------------+------------------------------+
16 rows in set

OceanBase Database allows you to specify a non-default character set for communication with the server. For example, to use the gbk character set, execute the following statement after connecting to the server:

obclient> SET NAMES gbk;
Query OK, 0 rows affected

In Oracle mode of OceanBase Database, the default collation is bin, but you can use the NLSSORT() function to specify other collations.

obclient> CREATE TABLE t(a VARCHAR(10));
Query OK, 0 rows affected

obclient> INSERT INTO t VALUES ('a'),('A'),('b'),('B'),('han1'),('han2'),('han3'),('han4'),('han5'),('zinc'),('zeta');
Query OK, 11 rows affected
Records: 11  Duplicates: 0  Warnings: 0

obclient> SELECT a,NLSSORT(a, 'NLS_SORT=SCHINESE_PINYIN2_M' ) FROM t ORDER BY NLSSORT(a, 'NLS_SORT=SCHINESE_PINYIN2_M' );
+------+------------------------------------------+
| A    | NLSSORT(A,'NLS_SORT=SCHINESE_PINYIN2_M') |
+------+------------------------------------------+
| A    | 41                                       |
| B    | 42                                       |
| a    | 61                                       |
| b    | 62                                       |
| han1 | FFA01016                                 |
| han2 | FFA01156                                 |
| han3 | FFA0115E                                 |
| han4 | FFA04E35                                 |
| han5 | FFA052DB                                 |
| zinc | FFA08A0F                                 |
| zeta | A6C6                                     |
+------+------------------------------------------+
11 rows in set

Conversion between GB18030 and GB18030_2022

The CONVERT function can explicitly convert a character set of a gb18030 string to gb18030_2022 without using Unicode encoding. This conversion uses the method of character encoding retention. For example, you can run the following statement:

obclient> CREATE TABLE t1 (c1 VARCHAR(10));
Query OK, 0 rows affected

obclient> INSERT INTO t1 VALUES ('Character');
Query OK, 1 row affected

obclient> SELECT RAWTOHEX(c1), RAWTOHEX(CONVERT(c1, 'ZHS32GB18030_2022')) FROM t1;
+--------------+-------------------------------------------+
| RAWTOHEX(C1) | RAWTOHEX(CONVERT(C1,'ZHS32GB18030_2022')) |
+--------------+-------------------------------------------+
| D7D6         | D7D6                                      |
+--------------+-------------------------------------------+
1 row in set

In OceanBase Database's Oracle mode, the character set is at the tenant level. In a tenant that uses the gb18030_2022 character set, all user tables have the CHAR, VARCHAR2, and CLOB fields of the gb18032_2022 character set, and they are all sorted in the binary order (gb18030_2022_bin). In Oracle mode, string literals are converted to the tenant character set during parsing to ensure consistency in SQL character sets.

/* The `gb18030_2022` tenant's column c uses the `gb18030_2022` character set and the `gb18030_2022_bin` collation. */
obclient> CREATE TABLE t1(c VARCHAR(100));
Query OK, 0 rows affected

obclient> INSERT INTO t1 values('character');
Query OK, 1 row affected

-- Set the character set to GB18030 for the client.
obclient> SET NAMES gb18030;
Query OK, 0 rows affected

/* The string 'character' is converted to gb18030_2022 by SQL during parsing, and the SQL statement executes normally without error. */
obclient> SELECT * FROM t1 WHERE c = 'Characters';
+------+
| C    |
+------+
| Word |
+------+
1 row in set

References

NLSSORT

nls_sort

nls_characterset

nls_nchar_characterset