Attribute

BindParamsAsUnicode (BPAU)

Purpose

Specifies whether the driver converts data in bind parameters from the SQL_CHAR, SQL_VARCHAR and SQL_LONGVARCHAR ODBC data types to the SQL_WCHAR, SQL_WVARCHAR, and SQL_WLONGVARCHAR types when C type is set to SQL_C_WCHAR. When certain applications bind SQL_C_WCHAR data to a non-Unicode ODBC type, this behavior may result in the substitution of some characters. Enabling this option allows you to avoid character substitution by configuring the driver to use the corresponding Unicode ODBC type.

Valid Values

0 | 1

Behavior

If set to 1 (Enabled), the driver converts data bound to the SQL_CHAR, SQL_VARCHAR and SQL_LONGVARCHAR ODBC data types to the SQL_WCHAR, SQL_WVARCHAR, and SQL_WLONGVARCAR data types when C type is set to SQL_C_WCHAR.

If set to 0 (Disabled), the driver does not convert data bound to the SQL_CHAR, SQL_VARCHAR and SQL_LONGVARCHAR data types.

Default

0 (Disabled)

GUI Tab

Advanced Tab