Note
Starting from V2.2.77, this variable was introduced.
Description
nls_comp specifies the string value comparison rule.
Applicability
This variable applies only to the Oracle mode of OceanBase Database.
Permissions
Query variables
Global scope
Tenants of the
systenant and all user tenants can use theSHOW VARIABLESstatement or theSYS.TENANT_VIRTUAL_GLOBAL_VARIABLEview (in Oracle mode) to query the values of global system variables.Session scope
Tenants of the
systenant and all user tenants can use theSHOW VARIABLESstatement or theSYS.TENANT_VIRTUAL_SESSION_VARIABLEview (in Oracle mode) to query the values of session system variables.
Modify variables
Tenants of the
systenant and all user tenants cannot modify the values of global or session system variables of their own.
Attribute description
| Attribute | Description |
|---|---|
| Parameter type | Varchar |
| Default value | BINARY |
| Effective scope |
|
| Modifiability | No, the variable is not supported. |
| Plan generation affected | Yes |