Note
This variable is available starting with V2.2.77.
Description
nls_sort specifies the sort order for string values.
Applicability
This variable is applicable only to OceanBase Database in Oracle mode.
Privilege requirements
Query variables
Global level
systenants 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
systenants 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 | BINARY |
| Scope |
|
| Modifiable | No. This variable is read-only. |