The following table lists the data types supported by the Advantage JDBC driver and how they are mapped to the JDBC data types.
Advantage Data Type |
JDBC Data Type |
AutoInc |
BIGINT |
Blob |
LONGVARBINARY |
Char |
CHAR |
CIChar |
CHAR |
CurDouble |
DOUBLE |
Date |
DATE |
Double |
DOUBLE |
Integer |
INTEGER |
Logical |
BIT |
Memo |
LONGVARCHAR |
Money |
DECIMAL |
Numeric |
NUMERIC |
Raw |
BINARY |
Short |
SMALLINT |
Time |
TIME |
TimeStamp |
TIMESTAMP |
RowVersion |
BIGINT |
ModTime |
TIMESTAMP |
Varchar |
VARCHAR |
Varbinary |
VARBINARY |