Progress
ODBC Driver Guide


Progress and ODBC Data Types

This appendix shows how the Progress data types are mapped to the standard ODBC data types.

Table B–1 shows how the Progress data types are mapped to the standard ODBC data types.

Table B–1: Progress 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 © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095