The incoming target ODBC datatypes are initially converted to Open Server datatypes.These datatypes are converted into the datatypes specified by the destinationtemplatestatement datatype qualifiers.
ODBC Datatype |
Open Server Datatype |
|---|---|
CHAR |
CS_CHAR |
VARCHAR |
CS_CHAR |
LONGVARCHAR |
CS_TEXT |
SMALLINT |
CS_SMALLINT |
INT |
CS_INT |
DECIMAL |
CS_DECIMAL |
DOUBLE |
CS_FLOAT |
REAL |
CS_REAL |
FLOAT |
CS_FLOAT |
DATE |
CS_CHAR |
TIME |
CS_CHAR |
TIMESTAMP |
CS_CHAR |
BINARY |
CS_BINARY |
VARBINARY |
CS_VARBINARY |
LONGVARBINARY |
CS_IMAGE |
TINYINT |
CS_TINYINT |
BIT |
CS_BIT |
BIGINT |
CS_FLOAT |
NUMERIC |
CS_NUMERIC |