Enable N-CHAR Support
- Last Updated: October 27, 2020
- 1 minute read
- DataDirect Connectors
- ODBC
- Oracle Database Wire Protocol 8.0
- Documentation
Attribute
Note: The Enable N-CHAR Support connection option has been deprecated, and the
driver behavior has been updated to always provide support for the N-types NCHAR, NVARCHAR2
and NCLOB. For compatibility purposes, the EnableNcharSupport attribute can still be
manually configured for this release, but will be deprecated in subsequent versions of the
product. To configure the attribute on Windows, use the Extended Options field on the
Advanced tab. For UNIX/Linux, using a text editor, add the attribute to your data source in
the odbc.ini file.
EnableNcharSupport (ENS)
Purpose
Determines whether the driver provides support for the N-types NCHAR, NVARCHAR2, and NCLOB. These types are described as SQL_WCHAR, SQL_WVARCHAR, and SQL_WLONGVARCHAR, and are returned as supported by SQLGetTypeInfo. In addition, the "normal" char types (char, varchar2, long, clob) are described as SQL_CHAR, SQL_VARCHAR, and SQL_LONGVARCHAR regardless of the character set on the Oracle server.
Valid Values
0 | 1
Behavior
If set to 1 (Enabled), the driver provides support for the N-types NCHAR, NVARCHAR2, and NCLOB.
If set to 0 (Disabled), the driver does not provide support for the N-types NCHAR, NVARCHAR2, and NCLOB.
Notes
- Valid only on Oracle 9i and higher.
Default
None
See also
GUI Tab
None