Note
This variable is available starting with V2.2.77.
Description
nls_nchar_conv_excp specifies whether to return an error when data is lost during the conversion between NCHAR/NVARCHAR2 and CHAR/VARCHAR2.
Applicability
This variable is applicable only to OceanBase Database in Oracle-compatible mode.
Privilege requirements
Query variables
Global level
systenants and all user tenants can execute theSHOW VARIABLESstatement or query theSYS.TENANT_VIRTUAL_GLOBAL_VARIABLEview (Oracle-compatible mode) to view the values of global system variables.Session level
systenants and all user tenants can execute theSHOW VARIABLESstatement or query theSYS.TENANT_VIRTUAL_SESSION_VARIABLEview (Oracle-compatible mode) to view the values of session system variables.
Modify variables
This variable cannot be modified.
Attributes
| Attribute | Description |
|---|---|
| Type | Bool |
| Default value | FALSE |
| Value range |
|
| Scope |
|
| Modifiable | No. This variable is read-only. |