Warning 1000119

"The data to be inserted into table '%2', column `%1' from row %3 of the select results cannot be converted to the datatype of the destination column. NULL will be inserted if the column allows NULLs."

Item	Description
SQLCode	1000119L
Constant	EMSG_CANNOT_CONVERT_FOR_INSERT_SELECT
SQLState	00B19
ODBC 2 State	OK
ODBC 3 State	OK
Sybase Error Code	20779
Severity Code	1
Parameter 1	The table being inserted to.
Parameter 2	The column being inserted to.
Parameter 3	The row number in the SELECT results that contains the data that cannot be converted.

Probable cause

The database option CONVERSION_ERROR has been set to 'OFF' for this INSERT...SELECT. During INSERT...SELECT, the data to be inserted to one of the columns cannot be converted to the datatype of that column. If the column allows NULL, then NULL will be inserted instead.