Btrieve | ODBC |
Autoincrement(2) | SQL_SMALLINT |
Autoincrement(4) | SQL_INTEGER |
Bfloat(4) | SQL_REAL |
Bfloat(8) | SQL_DOUBLE |
Bit | SQL_BIT |
Blob | SQL_LONGVARGBINARY |
Char | SQL_CHAR |
Currency | SQL_DECIMAL |
Date | SQL_TYPE_DATE |
Decimal | SQL_DECIMAL |
Float(4) | SQL_REAL |
Float(8) | SQL_DOUBLE |
Integer(1) | SQL_TINYINT |
Integer(2) | SQL_SMALLINT |
Integer(4) | SQL_INTEGER |
Integer(8) | SQL_BIGINT |
Logical(1) | SQL_BIT |
Logical(2) | SQL_BIT |
Lstring | SQL_VARCHAR |
Money | SQL_DECIMAL |
Note | SQL_LONGVARCHAR |
Numeric | SQL_NUMERIC |
Numericsts | SQL_NUMERIC |
Time | SQL_TYPE_TIME |
Timestamp | SQL_TYPE_TIMESTAMP |
Unsigned(1) | SQL_TINYINT |
Unsigned(8) | SQL_BIGINT |
Zstring | SQL_VARCHAR |