Note
This variable is introduced in V2.2.77.
Description
nls_nchar_conv_excp specifies whether to report an error when data is lost during the conversion between NCHAR/NVARCHAR2 and CHAR/VARCHAR2.
Functionality applicability
This parameter is only for OceanBase Database in Oracle mode.
Privilege requirements
Query variables
Global level
You can run the
SHOW VARIABLESstatement or query theSYS.TENANT_VIRTUAL_GLOBAL_VARIABLEview (Oracle mode) to view the values of global system variables in thesystenant or all user tenants.Session level
Both the
systenant and all user tenants can query the value of a session system variable by using theSHOW VARIABLESstatement or 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 | TRUE: reports an error in case of data loss.FALSE: does not report an error in case of data loss. |
| Applicable scope | |
| Modifiable | No. This variable is read-only. |