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
systenant and all user tenants can use theSHOW VARIABLESstatement or theSYS.TENANT_VIRTUAL_GLOBAL_VARIABLEview (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. |