iAnywhere Solutions ODBC Drivers
iAnywhere Solutions ODBC Driver for Sybase Adaptive Server Enterprise
The following table shows how the Sybase data types are mapped to the standard ODBC data types.
| Adaptive Server Enterprise | ODBC |
|---|---|
| binary | SQL_BINARY |
| bit | SQL_BIT |
| char | SQL_CHAR |
| datetime | SQL_TYPE_TIMESTAMP |
| decimal | SQL_DECIMAL |
| float | SQL_FLOAT |
| image | SQL_LONGVARBINARY |
| int | SQL_INTEGER |
| money | SQL_DECIMAL |
| numeric | SQL_NUMERIC |
| real | SQL_REAL |
| smalldatetime | SQL_TYPE_TIMESTAMP |
| smallint | SQL_SMALLINT |
| smallmoney | SQL_DECIMAL |
| sysname | SQL_VARCHAR |
| text | SQL_LONGVARCHAR |
| timestamp | SQL_TYPE_TIMESTAMP |
| tinyint | SQL_TINYINT |
| varbinary | SQL_VARBINARY |
| varchar | SQL_VARCHAR |
Adaptive Server Enterprise 12.5The iAnywhere Solutions ODBC driver supports extended new limits (XNL) for character and binary columns—columns with lengths greater than 255. |