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.
Usage in TimesTen Scaleout and TimesTen Classic
This attribute is supported in both TimesTen Classic and TimesTen Scaleout.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 |
|
|
Windows ODBC Data Source Administrator |
Not applicable |