skip to main content
Part 2: The 32-Bit/64-Bit Drivers : The Sybase Wire Protocol Driver : Unicode Support
  
Unicode Support
When connected to a Unicode database, the Sybase Wire Protocol driver supports Unicode data types listed in the following table, in addition to standard ODBC data types listed in Data Types.
Sybase Data Type
Mapped to. . .
CHAR 1
SQL_WCHAR
SYSNAME2
SQL_VARCHAR
TEXT3
SQL_WLONGVARCHAR
UNICHAR 4
SQL_WCHAR
UNITEXT5
SQL_WLONGVARCHAR
UNIVARCHAR6
SQL_WVARCHAR
VARCHAR 7
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.

4 On Sybase 12.5 servers, this data type is available only if the data source is configured to use the UTF-8 character set. On Sybase 12.5.1 and higher servers, this data type is always available, even if the data source is not configured to use the UTF-8 character set.

5 This data type is available on Sybase 15 and higher servers only.

6 On Sybase 12.5 servers, this data type is available only if the data source is configured to use the UTF-8 character set. On Sybase 12.5.1 and higher servers, this data type is always available, even if the data source is not configured to use the UTF-8 character set.

7 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.