|
|
|
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 |
