|
Supported Data Types - ODBC Driver for Firebird |
|
|
|
Supported Data Types - ODBC Driver for Firebird |
|
The Devart ODBC Driver for Firebird supports all Firebird data types.
The following table describes how the Firebird data types are mapped to the ODBC data types.
| Firebird 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 |