Release 10.1A: OpenEdge Data Management:
SQL Reference

> ## OpenEdge SQL and ODBC Data Types

> This section shows how the OpenEdgeŽ SQL data types are mapped to the standard ODBC data types.

> Table 63 shows how the OpenEdge SQL data types are mapped to the standard ODBC data types.

> Table 63: 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

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095