Documentation

ODBC Driver Guide

Previous Topic

Next Topic

Supported Data Types

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

c-treeSQL ODBC and Corresponding ODBC Data Types

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