NLS_NCHAR_CONV_EXCP

The NLS_NCHAR_CONV_EXCP attribute determines whether an error is reported when there is data loss during an implicit or explicit character type conversion between NCHAR/NVARCHAR2 data and CHAR/VARCHAR2 data.

A replacement character is substituted for characters that cannot be converted, and implicit and explicit conversions between CHAR and NCHAR are supported.

NLS_NCHAR_CONV_EXCP can be modified by an ALTER SESSION SQL statement, described in Oracle TimesTen In-Memory Database SQL Reference.

Required Privilege

No privilege is required to change the value of this attribute.

Setting

Set NLS_NCHAR_CONV_EXCP as follows:

Where to Set the Attribute	How the Attribute is Represented	Setting
C or Java programs or UNIX and Linux systems odbc.ini file in TimesTen	NLS_NCHAR_CONV_EXCP	0 (default) - Errors are not reported when there is a data loss during character type conversion. 1 - Errors are reported when there is a data loss during character type conversion.
Windows ODBC Data Source Administrator	Not applicable