Unicode Support
- Last Updated: October 7, 2020
- 2 minute read
- DataDirect Connectors
- ODBC
- Cloudera Impala 7.1
- dBase 7.1
- Flat files/Text 7.1
- MySQL 7.1
- Pervasive (Btrieve) 7.1
- XML 7.1
- Documentation
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 |
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 Progress DataDirect for ODBC Drivers Reference for a more detailed explanation of Unicode.