Sybase Error – 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.

In this blog post, you’ll learn more about the Sybase Error 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. and the reason for receiving this error

Sybase SQL Error Message

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.

Reason for this Error

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.