Error 1000187

Message text

Unable to implicitly convert column '%2' to datatype (%3) from datatype (%4). %1

Item

Value

SQLCode

-1000187L

Constant

EMSG_SQL_IMPLICITCONVERSION

SQLState

QCB87

ODBC State

ERROR

Parameter 1

location of the exception

Parameter 2

name of column being converted

Parameter 3

data type being converted to

Parameter 4

data type being converted from

Probable cause

The attempted implicit data type conversion is not possible. The conversion must be done explicitly.

If you attempt an implicit conversion to or from a NUMERIC column and this error is returned, the data type displayed in the error for the NUMERIC column is SMALLINT, INT, or INT64, depending on the precision of the NUMERIC. NUMERIC columns are treated internally as multiple precision signed integers.