Documentation

FairCom ODBC

Previous Topic

Next Topic

Supported Data Types

FairCom DB SQL supports a set of data types that the FairCom DB ODBC Driver maps to corresponding ODBC SQL data types. The following table lists the FairCom DB SQL data types and the corresponding ODBC data types.

c-treeSQL ODBC and Corresponding ODBC Data Types

FairCom DB ODBC Data Type

ODBC Data Type

BIGINT

SQL_BIGINT

BINARY

SQL_BINARY

BIT

SQL_BIT

CHAR or CHARACTER

SQL_CHAR

DATE

SQL_DATE

DECIMAL

SQL_DECIMAL

DOUBLE PRECISION

SQL_DOUBLE

FLOAT

SQL_FLOAT

INTEGER

SQL_INTEGER

LVARBINARY

SQL_LONGVARBINARY

LVARCHAR

SQL_LONGVARCHAR

MONEY

SQL_NUMERIC

NUMERIC

SQL_NUMERIC

REAL

SQL_REAL

SMALLINT

SQL_SMALLINT

TIME

SQL_TIME

TIMESTAMP

SQL_TIMESTAMP

TINYINT

SQL_TINYINT

VARBINARY

SQL_VARBINARY

VARCHAR

SQL_VARCHAR

TOCIndex