skip to main content
Part 2: The 32-Bit/64-Bit Drivers : The Progress OpenEdge Wire Protocol Driver : Data Types
  
Data Types
The following table shows how the Progress OpenEdge data types are mapped to the standard ODBC data types.
Table 29. Progress OpenEdge Data Types
OpenEdge
ODBC
Bigint
SQL_BIGINT
Binary
SQL_BINARY
Bit
SQL_BIT
Blob
SQL_LONGVARBINARY
Char
SQL_CHAR
Clob
SQL_LONGVARCHAR
Date
SQL_TYPE_DATE
Decimal
SQL_DECIMAL
Double precision
SQL_DOUBLE
Float
SQL_FLOAT
Integer
SQL_INTEGER
Lvarbinary
SQL_LONGVARBINARY
Lvarchar
SQL_LONGVARCHAR
Numeric
SQL_NUMERIC
Real
SQL_FLOAT
Smallint
SQL_SMALLINT
Time
SQL_TYPE_TIME
Timestamp
SQL_TYPE_TIMESTAMP
Timestamp with Time Zone
SQL_CHAR
Tinyint
SQL_TINYINT
Varbinary
SQL_VARBINARY
Varchar
SQL_VARCHAR
See Retrieving Data Type Information for more information about data types.