Try OpenEdge Now
skip to main content
SQL Reference
ODBC Reference : OpenEdge SQL and ODBC Data Types
 

OpenEdge SQL and ODBC Data Types

The following table shows how the OpenEdge SQL data types are mapped to the standard ODBC data types:
Table 64. OpenEdge SQL and ODBC data types
Progress data type
ODBC data type
BINARY
SQL_BINARY
BIT
SQL_BIT
CHAR
SQL_CHAR
DATE
SQL_TYPE_DATE
DECIMAL
SQL_DECIMAL
DOUBLE PRECISION
SQL_DOUBLE
FLOAT
SQL_FLOAT
INTEGER
SQL_INTEGER
REAL
SQL_FLOAT
SMALLINT
SQL_SMALLINT
TIME
SQL_TYPE_TIME
TIMESTAMP
SQL_TYPE_TIMESTAMP
TINYINT
SQL_TINYINT
VARBINARY
SQL_VARBINARY
LVARBINARY
SQL_LONGVARBINARY
VARCHAR
SQL_VARCHAR