The following table shows how the OpenEdge SQL data types are mapped to the standard ODBC data types:

Table 1. OpenEdge SQL and ODBC data types
Progress data type ODBC data type
BINARY SQL_BINARY
BIT SQL_BIT
CHAR SQL_CHAR
DATE SQL_DATE
DECIMAL SQL_DECIMAL
DOUBLE PRECISION SQL_DOUBLE
FLOAT SQL_FLOAT
INTEGER SQL_INTEGER
REAL SQL_FLOAT
SMALLINT SQL_SMALLINT
TIME SQL_TIME
TIMESTAMP SQL_TIMESTAMP
TINYINT SQL_TINYINT
VARBINARY SQL_VARBINARY
LVARBINARY SQL_LONGVARBINARY
VARCHAR SQL_VARCHAR