Sybase Error – The data to be inserted into table ‘%2’, column ‘%1’ cannot be converted to the datatype of the 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’ cannot be converted to the datatype of the 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’ cannot be converted to the datatype of the 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. The data to be inserted to the named column cannot be converted to the datatype of that column. If the column allows NULL, then NULL will be inserted instead.