nls_comp

最終更新:2026-09-04 09:45:16

This variable was introduced in V2.2.77.

Description

nls_comp specifies the string value comparison rule.

This variable applies only to the Oracle mode of OceanBase Database.

Query variables
- Global scope
  
  Tenants with the sys privilege and all user tenants can execute the SHOW VARIABLES statement or query the SYS.TENANT_VIRTUAL_GLOBAL_VARIABLE view (in Oracle mode) to obtain the values of global system variables.
- Session scope
  
  Tenants with the sys privilege and all user tenants can execute the SHOW VARIABLES statement or query the SYS.TENANT_VIRTUAL_SESSION_VARIABLE view (in Oracle mode) to obtain the values of session system variables.
Modify variables

Tenants with the sys privilege and all user tenants cannot modify the values of global or session system variables in their own tenants.

Attribute	Description
Parameter type	Varchar
Default value	BINARY
Applicable scope	GLOBAL SESSION
Modifiable	No, this variable cannot be modified.
Plan generation affected	Yes

次のトピック