Supported Data Types
c-treeSQL supports a set of data types that the c-treeSQL ODBC Driver maps to corresponding ODBC SQL data types. The following table lists the c-treeSQL data types and the corresponding ODBC data types.
c-treeSQL ODBC and Corresponding ODBC Data Types
c-treeSQL 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
|
|
