skip to main content
Supported data types : Progress OpenEdge data types
 

Try DataDirect Cloud Now

Progress OpenEdge data types

The following table lists the Progress OpenEdge data types and their equivalents for JDBC and ODBC.
Table 17. OpenEdge data types
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)