Note
This variable is available starting with OceanBase Database 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 mode.
Privilege requirements
Query variables
Global level
systenant and all user tenants can query the value of a Global system variable by executing theSHOW VARIABLESstatement or querying theSYS.TENANT_VIRTUAL_GLOBAL_VARIABLEview (Oracle mode).Session level
systenant and all user tenants can query the value of a Session system variable by executing theSHOW VARIABLESstatement or querying theSYS.TENANT_VIRTUAL_SESSION_VARIABLEview (Oracle mode).
Modify variables
This variable cannot be modified.
Attributes
| Attribute | Description |
|---|---|
| Parameter type | Bool |
| Default value | FALSE |
| Value range |
|
| Scope |
|
| Modifiable | No. This variable is read-only. |