"Unable to implicitly convert column '%2' to datatype (%3) from datatype (%4). %1"
| Item | Description |
|---|---|
|
SQLCode |
-1000187L |
|
Constant |
EMSG_SQL_IMPLICITCONVERSION |
|
SQLState |
QCB87 |
|
ODBC 2 State |
ERROR |
|
ODBC 3 State |
ERROR |
|
Sybase Error Code |
20847 |
|
Severity Code |
|
|
Parameter 1 |
location of the exception |
|
Parameter 2 |
column converting |
|
Parameter 3 |
datatype being converted to |
|
Parameter 4 |
datatype being converted from |
The attempted implicit conversion is not possible. The conversion must be done explicitly. If implicit conversion is being attempted to or from a NUMERIC and this error results, the datatype displayed in the error for the NUMERIC will be SMALLINT, INT, or INT64 depending on the precision of the NUMERIC. This is because NUMERICs are treated internally as multiple precision signed integers.