Datatype conversion for transfer statements

Table 9-2 shows the acceptable source datatypes that the access service can convert into corresponding target destination datatypes.

**Table 9-2: Datatype conversions**
Source datatypes	Target datatypes
Source datatypes	CHAR, VARCHAR, LONGVARCHAR, TEXT (CLOB),	BIGINT, DECIMAL, DOUBLE FLOAT, INTEGER, MONEY, MONEY4, NUMERIC, REAL, SMALLINT, TINYINT	DATETIME, DATETIME4, TIMESTAMP	BINARY, VARBINARY, LONGVARBINARY, IMAGE (BLOB)	BIT
CHAR, VARCHAR, LONGVARCHAR, TEXT (CLOB)	X	X	X	X	X
BIGINT, DECIMAL, DOUBLE, FLOAT, INTEGER, MONEY, MONEY4, NUMERIC, REAL, SMALLINT, TINYINT	X	X
BINARY, VARBINARY, LONGVARBINARY, IMAGE (BLOB)	X			X
DATETIME, DATETIME4, TIMESTAMP	X		X
BIT	X	X			X

Datatypes resulting from this conversion are converted into actual datatypes in the target column. If a column match is incompatible, the transfer ends with an error.