nls_characterset

2025-11-14 07:33:33  Updated

Note

The variable was introduced in V2.2.77.

Description

The nls_characterset variable is used to view the default character set of the CHAR, VARCHAR2, and CLOB data types in the database.

Applicability

The variable applies only to OceanBase Database's Oracle-compatible mode.

Privilege requirements

  • Query variables

    Both the sys tenant and all user tenants can use the SHOW VARIABLES statement or the SYS.TENANT_VIRTUAL_GLOBAL_VARIABLE view (in Oracle-compatible mode) to query the values of global system variables.

  • Modify variables

    The value of this variable cannot be modified.

Attributes

Attribute Description
Parameter type Varchar
Default value AL32UTF8
Effect scope Global
Modifiable No, the variable is read-only.

Contact Us