Note
This variable is available starting with V2.2.77.
Description
nls_length_semantics specifies the LENGTH semantics of the CHAR and VARCHAR2 data types.
Applicability
This variable applies only to OceanBase Database in Oracle mode.
Privilege requirements
Query variables
Global level
systenant and all user tenants can execute theSHOW VARIABLESstatement or query theSYS.TENANT_VIRTUAL_GLOBAL_VARIABLEview (Oracle mode) to view the value of a global system variable.Session level
systenant and all user tenants can execute theSHOW VARIABLESstatement or query theSYS.TENANT_VIRTUAL_SESSION_VARIABLEview (Oracle mode) to view the value of a session system variable.
Modify variables
This variable cannot be modified.
Attributes
Attribute |
Description |
|---|---|
| Type | Varchar |
| Default value | BYTE |
| Value range |
|
| Scope |
|
| Modifiable | No. This variable is read-only. |