The following table lists the data types supported by the Sybase driver and how they are mapped to the JDBC data types.

Table 1. Sybase Data Types
Sybase Data Type JDBC Data Type
BIGINT 1 BIGINT
BIGDATETIME 2 TIMESTAMP
BIGTIME 3, 4 TIME or TIMESTAMP
BINARY BINARY
BIT BIT
CHAR CHAR
DATE 5 DATE
DATETIME TIMESTAMP
DECIMAL DECIMAL
FLOAT FLOAT
IMAGE LONGVARBINARY
INT INTEGER
MONEY DECIMAL
NUMERIC NUMERIC
REAL REAL
SMALLDATETIME TIMESTAMP
SMALLINT SMALLINT
SMALLMONEY DECIMAL
SYSNAME VARCHAR
TEXT LONGVARCHAR
TIME 6, 7 TIME or TIMESTAMP
TIMESTAMP VARBINARY
TINYINT TINYINT
UNICHAR 8 NCHAR
UNITEXT 9 LONGNVARCHAR
UNIVARCHAR 10 NVARCHAR
UNSIGNED BIGINT 11 DECIMAL
UNSIGNED INT 12 BIGINT
UNSIGNED SMALLINT 13 INTEGER
VARBINARY VARBINARY
VARCHAR VARCHAR
Note: FOR USERS OF SYBASE 12.5 AND HIGHER: The Sybase driver supports extended new limits (XNL) for character and binary columns—columns with lengths greater than 255. Refer to your Sybase documentation for more information about XNL for character and binary columns.
1 Supported only for Sybase 15.0 and higher.
2 Supported only for Sybase 15.5 and higher.
3 Supported only for Sybase 15.5 and higher.
4 When FetchTWFSasTime=true, this Sybase data type is mapped to the JDBC TIME data type. When FetchTWFSasTime=false, this Sybase data type is mapped to the JDBC TIMESTAMP data type.
5 Supported only for Sybase 12.5 and higher.
6 When FetchTWFSasTime=true, this Sybase data type is mapped to the JDBC TIME data type. When FetchTWFSasTime=false, this Sybase data type is mapped to the JDBC TIMESTAMP data type.
7 Supported only for Sybase 12.5 and higher.
8 Supported only for Sybase 12.5 and higher.
9 Supported only for Sybase 15.0 and higher.
10 Supported only for Sybase 12.5 and higher.
11 Supported only for Sybase 15.0 and higher.
12 Supported only for Sybase 15.0 and higher.
13 Supported only for Sybase 15.0 and higher.