ODBC Driver for InterBase

Supported Data Types - ODBC Driver for InterBase

Data Type Mapping

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

© 2015-2022 Devart. All Rights Reserved. Request Support ODBC Forum Provide Feedback