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 |
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.