Progress OpenEdge Data Type | JDBC Data Type |
bigint | BIGINT |
binary | BINARY |
bit | BIT |
blob | LONGVARBINARY |
character | CHAR |
clob | LONGVARCHAR |
date | DATE |
double precision | DOUBLE |
float | DOUBLE |
integer | INTEGER |
lvarbinary | LONGVARBINARY |
lvarchar | LONGVARCHAR |
numeric | NUMERIC |
real | REAL |
smallint | SMALLINT |
time | TIME |
timestamp | TIMESTAMP |
timestamp with time zone | CHAR |
tinyint | TINYINT |
varbinary | VARBINARY |
varchar | VARCHAR |