nls_length_semantics

2026-02-12 02:58:32  Updated

Note

The variable is available from V2.2.77.

Description

nls_length_semantics specifies the length semantics of the char and varchar2 data types.

Applicability of the feature

This variable applies only to Oracle mode of OceanBase Database.

Privilege requirements

  • Query variables

    • Global level

      The sys tenant and all user tenants can use the SHOW VARIABLES statement or the SYS.TENANT_VIRTUAL_GLOBAL_VARIABLE view (Oracle mode) to query the values of global system variables.

    • Session level

      sys tenants and all user tenants can use the SHOW VARIABLES statement or view SYS.TENANT_VIRTUAL_SESSION_VARIABLE (Oracle mode) to view the values of session system variables.

  • Modify variables

    This variable is read-only.

Attributes

Attribute Description
Parameter type Varchar
Default value BYTE
Value range
  • BYTE
  • CHAR
  • Applicable scope
  • Global
  • Session
  • Is it modifiable? No. The variable supports read-only access.

    Contact Us