Datatype conversion for transfer to statements

Datatype conversion takes place in two steps. Table 10-6 shows how incoming target ODBC datatypes are initially converted to Open Server datatypes.

**Table 10-6: Datatype conversion for **“transfer to”** statements**
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

These datatypes are converted into the datatypes specified by the destinationtemplatestatement datatype qualifiers.