skip to main content
Part 4: The Connect XE Drivers : The Sybase IQ Wire Protocol Driver : Unicode Support
  
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 Data Types.
Table 81. 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 2
SQL_WLONGVARCHAR
UNIQUEIDENTIFIERSTR
SQL_WCHAR
VARCHAR 3
SQL_WVARCHAR

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

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

3 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 "Internationalization, Localization, and Unicode" in the DataDirect Connect Series for ODBC Reference for a more detailed explanation of Unicode.