skip to main content
Connection Option Descriptions : Enable N-CHAR Support
  

Try DataDirect Drivers Now

Enable N-CHAR Support

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.

Attribute

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

*Advanced Tab

GUI Tab

None