ODBC Driver for InterBase

Supported Data Types

ODBC Driver for InterBase supports all the InterBase data types.

The complete list of InterBase data types is available in the InterBase documentation.

Data Type Mapping

The following table describes how ODBC data types are mapped to InterBase 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-2017 Devart. All Rights Reserved. Request Support ODBC Forum Provide Feedback