Note
This variable is available starting with V2.2.77.
Description
nls_sort specifies the collation of string values.
Applicability
This variable is applicable only to OceanBase Database in Oracle mode.
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 values of global system variables.Session level
The
systenant and all user tenants can execute theSHOW VARIABLESstatement or query theSYS.TENANT_VIRTUAL_SESSION_VARIABLEview (Oracle mode) to view the values of session system variables.
Modify variables
You cannot modify this variable.
Attributes
| Attribute | Description |
|---|---|
| Type | Varchar |
| Default value | BINARY |
| Scope |
|
| Modifiable | No. This variable is read-only. |