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 CHAR or NCHAR 9
UNITEXT 10 LONGVARCHAR or LONGNVARCHAR 11
UNIVARCHAR 12 VARCHAR or NVARCHAR 13
UNSIGNED BIGINT 14 DECIMAL
UNSIGNED INT 15 BIGINT
UNSIGNED SMALLINT 16 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 When JDBCBehavior=0, the data type depends on the JVM the application uses. For JVMs earlier than Java SE 6, the first value applies. For Java SE 6 and higher, the second value applies.
10 Supported only for Sybase 15.0 and higher.
11 When JDBCBehavior=0, the data type depends on the JVM the application uses. For JVMs earlier than Java SE 6, the first value applies. For Java SE 6 and higher, the second value applies.
12 Supported only for Sybase 12.5 and higher.
13 When JDBCBehavior=0, the data type depends on the JVM the application uses. For JVMs earlier than Java SE 6, the first value applies. For Java SE 6 and higher, the second value applies.
14 Supported only for Sybase 15.0 and higher.
15 Supported only for Sybase 15.0 and higher.
16 Supported only for Sybase 15.0 and higher.