Note
The variable is available from V2.2.77.
Description
nls_length_semantics specifies the length semantics of the char and varchar2 data types.
Applicability of the feature
This variable applies only to Oracle mode of OceanBase Database.
Privilege requirements
Query variables
Global level
The
systenant and all user tenants can use theSHOW VARIABLESstatement or theSYS.TENANT_VIRTUAL_GLOBAL_VARIABLEview (Oracle mode) to query the values of global system variables.Session level
systenants and all user tenants can use theSHOW VARIABLESstatement or viewSYS.TENANT_VIRTUAL_SESSION_VARIABLE(Oracle mode) to view the values of session system variables.
Modify variables
This variable is read-only.
Attributes
| Attribute | Description |
|---|---|
| Parameter type | Varchar |
| Default value | BYTE |
| Value range | |
| Applicable scope | |
| Is it modifiable? | No. The variable supports read-only access. |