The Devart ODBC Driver for InterBase supports all InterBase data types.
The following table describes how the InterBase data types are mapped to the ODBC data types.
InterBase Data Types | ODBC Data Types |
---|---|
INT64 |
SQL_INTEGER |
TIMESTAMP |
SQL_TYPE_TIMESTAMP |
DECIMAL |
SQL_DECIMAL |
FLOAT |
SQL_REAL |
BLOB |
SQL_LONGVARBINARY |
INTEGER |
SQL_INTEGER |
DECIMAL(18, 4) |
SQL_DECIMAL |
CHAR(x) CHARACTER SET UNICODE_FSS |
SQL_VARCHAR |
BLOB SUB_TYPE TEXT |
SQL_LONGVARCHAR |
NUMERIC |
SQL_NUMERIC |
VARCHAR(x) CHARACTER SET UNICODE_FSS |
SQL_VARCHAR |
DOUBLE |
SQL_DOUBLE |
SMALLINT |
SQL_SMALLINT |
DECIMAL(10, 4) |
SQL_DECIMAL |
CHAR |
SQL_CHAR |
VARCHAR |
SQL_CHAR |
CHAR(38) |
SQL_CHAR |