Nucleus ODBC Setup Guide

 

ODBC Driver Data Type Conversions

The following conversions are made automatically when the Nucleus ODBC Driver encounters data types that are unsupported by SAND CDBMS:

Source Data Type SAND CDBMS Data Type
BIGINT DECIMAL(20,0)
BIT SMALLINT
DOUBLE DOUBLE PRECISION
LONG VARCHAR(n) VARCHAR(n)
TINYINT SMALLINT

Note:
The data type names shown in bold above cannot be used in CREATE TABLE, ALTER TABLE, or CREATE DOMAIN statements executed via an ODBC connection.

The Nucleus ODBC Driver reformats escape characters for DATE, TIME, and TIMESTAMP data types according to SAND CDBMS formats.

The following data types are not supported by the Nucleus ODBC driver; columns having these types cannot be imported to SAND CDBMS: