Note
This variable was introduced in V2.2.77.
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, including the
systenant, and users can execute theSHOW VARIABLESstatement or query theSYS.TENANT_VIRTUAL_GLOBAL_VARIABLEview (in Oracle mode) to view the values of global system variables.Session scope
Tenants, including the
systenant, and users can execute theSHOW VARIABLESstatement or query theSYS.TENANT_VIRTUAL_SESSION_VARIABLEview (in Oracle mode) to view the values of session system variables.
Modify variables
Tenants, including the
systenant, and users cannot modify the values of global or session system variables in their own tenants.
Attribute description
| Attribute | Description |
|---|---|
| Parameter type | Varchar |
| Default value | BINARY |
| Effective scope |
|
| Modifiability | No, this variable cannot be modified. |
| Plan generation affected | Yes |