skip to main content
DataDirect Connect Drivers : Sybase Driver : Data Types
  
Data Types
The following table lists the data types supported by the Sybase driver and how they are mapped to the JDBC data types.
Table 72. 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

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.

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.
Refer to "getTypeInfo()" in the DataDirect Connect Series for JDBC Reference for more information about data types.