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

Table 1. SAP ASE Data Type Mapping
SAP ASE Data Type... Maps to ODBC Data Type
BIGDATETIME SQL_DATETIME
BIGINT SQL_BIGINT
BIGTIME SQL_DATETIME
BINARY SQL_BINARY
BIT SQL_BIT
CHAR SQL_CHAR
DATE SQL_TYPE_DATE
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
TIME SQL_TYPE_TIME
TIMESTAMP SQL_VARBINARY
TINYINT SQL_TINYINT
UNSIGNED BIGINT2 SQL_BIGINT
UNSIGNED INT2 SQL_INTEGER
UNSIGNED SMALLINT SQL_SMALLINT
VARBINARY SQL_VARBINARY
VARCHAR SQL_VARCHAR