|
OpenEdge data type
|
JDBC data type
|
ODBC data type
|
|
bit
|
BIT
|
SQL_BIT(-7)
|
|
tinyint
|
TINYINT
|
SQL_TINYINT(-6)
|
|
bigint
|
BIGINT
|
SQL_BIGINT(-5)
|
|
lvarbinary
|
LONGVARBINARY
|
SQL_LONGVARBINARY(-4)
|
|
blob
|
LONGVARBINARY
|
SQL_LONGVARBINARY(-4)
|
|
varbinary
|
VARBINARY
|
SQL_VARBINARY(-3)
|
|
binary
|
BINARY
|
SQL_BINARY(-2)
|
|
lvarchar
|
LONGVARCHAR
|
SQL_LONGVARCHAR(-1) or SQL_WLONGVARCHAR (-10)
|
|
clob
|
LONGVARCHAR
|
SQL_LONGVARCHAR(-1) or SQL_WLONGVARCHAR (-10)
|
|
character
|
CHAR
|
SQL_CHAR(1) or SQL_WCHAR (-8)
|
|
timestamp with timezone
|
CHAR
|
SQL_CHAR(1) or SQL_WCHAR (-8)
|
|
numeric
|
NUMERIC
|
SQL_NUMERIC(2)
|
|
integer
|
INTEGER
|
SQL_INTEGER(4)
|
|
smallint
|
SMALLINT
|
SQL_SMALLINT(5)
|
|
real
|
REAL
|
SQL_REAL(7)
|
|
double precision
|
DOUBLE
|
SQL_DOUBLE(8)
|
|
float
|
DOUBLE
|
SQL_DOUBLE(8)
|
|
varchar
|
VARCHAR
|
SQL_VARCHAR(12) or SQL_WVARCHAR (-9)
|
|
date
|
DATE
|
SQL_TYPE_DATE(91)
|
|
time
|
TIME
|
SQL_TYPE_TIME(92)
|
|
timestamp
|
TIMESTAMP
|
SQL_TYPE_TIMESTAMP(93)
|