Unicode Support

When connected to a Unicode database, the Sybase IQ Wire Protocol driver supports the Unicode data types listed in the following table, in addition to standard ODBC data types listed in Table 22-2.

Table 22-3. Mapping Sybase IQ Data Types to Unicode Data Types 

Sybase IQ Data Type. . .	Maps to Unicode Data Type. . .
CHAR 1	SQL_WCHAR
LONG VARCHAR	SQL_WLONGVARCHAR
TEXT 1	SQL_WLONGVARCHAR
UNIQUEIDENTIFIERSTR	SQL_WCHAR
VARCHAR1	SQL_WVARCHAR

---

1

This data type is available only if the data source is configured to use the UTF-8 character set.

For data types that require the UTF-8 character set, set the Charset connection string attribute. See “Charset” for information about using this connection string attribute.

The driver supports the Unicode ODBC W (Wide) function calls, such as SQLConnectW. This allows the Driver Manager to transmit these calls directly to the driver. Otherwise, the Driver Manager would incur the additional overhead of converting the W calls to ANSI function calls, and vice versa.

See “UTF-16 Applications on UNIX and Linux” for related details. Also, refer to Chapter 4 “Internationalization, Localization, and Unicode” in the DataDirect Connect Series for ODBC Reference for a more detailed explanation of Unicode.