Note
This variable is available starting with OceanBase Database V2.2.77.
Description
nls_length_semantics specifies the semantics of the LENGTH function for the CHAR and VARCHAR2 data types.
Applicability
This variable is applicable only to the Oracle mode of OceanBase Database.
Privilege requirements
Query variables
Global level
The
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
The
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. |