Data Types

Table 12-2 shows how the Sybase data types are mapped to the standard ODBC data types. “Unicode Support” lists Sybase to Unicode data type mappings.

Table 12-2. Sybase Data Type Mapping 

Sybase Data Type...	Maps to ODBC Data Type
BIGDATETIME1	SQL_DATETIME
BIGINT 2	SQL_BIGINT
BIGTIME1	SQL_DATETIME
BINARY	SQL_BINARY
BIT	SQL_BIT
CHAR	SQL_CHAR
DATE 3	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 3	SQL_TYPE_TIME
TIMESTAMP	SQL_VARBINARY
TINYINT	SQL_TINYINT
UNSIGNED BIGINT2	SQL_BIGINT
UNSIGNED INT2	SQL_INTEGER
UNSIGNED SMALLINT 2	SQL_SMALLINT
VARBINARY	SQL_VARBINARY
VARCHAR	SQL_VARCHAR

---

1

Sybase 15.5 and higher only.

2

Sybase 15 and higher only.

3

Sybase 12.5.1 and higher only.

NOTE FOR USERS OF SYBASE 12.5 and higher: The Sybase Wire Protocol driver supports extended new limits (XNL) for character and binary columns—columns with lengths greater than 255.

See “Retrieving Data Type Information” for information about retrieving data types.