The following table shows how the Sybase IQ data types are mapped to the standard ODBC data types. For Sybase IQ to Unicode data type mappings, see "Driver Specifications."

Table 1. Sybase IQ Data Type Mapping
Sybase IQ Data Type... Maps to ODBC Data Type
BIGINT SQL_BIGINT
BINARY SQL_BINARY
BIT SQL_BIT
CHAR SQL_CHAR
DATE SQL_TYPE_DATE
DATETIME SQL_TYPE_TIMESTAMP
DECIMAL SQL_DECIMAL
DOUBLE SQL_DOUBLE
IMAGE SQL_LONGVARBINARY
INT SQL_INTEGER
LONG BINARY SQL_LONGVARBINARY
LONG VARCHAR SQL_LONGVARCHAR
MONEY SQL_DECIMAL
NUMERIC SQL_NUMERIC
REAL SQL_REAL
SMALLDATETIME SQL_TYPE_TIMESTAMP
SMALLINT SQL_SMALLINT
SMALLMONEY SQL_DECIMAL
TEXT SQL_LONGVARCHAR
TIME SQL_TYPE_TIME
TIMESTAMP SQL_TYPE_TIMESTAMP
TINYINT SQL_TINYINT
UNIQUEIDENTIFIER SQL_BINARY
UNIQUEIDENTIFIERSTR SQL_CHAR
UNSIGNED BIGINT SQL_BIGINT
UNSIGNED INT SQL_INTEGER
VARBINARY SQL_VARBINARY
VARCHAR SQL_VARCHAR
Note: The Sybase IQ Wire Protocol driver supports extended new limits (XNL) for character and binary columns—columns with lengths greater than 255.