Informix Error -2017: The character data value does not convert correctly to the field type.
Cause and resolution
The character data value does not convert correctly to the field type.
You have entered a character value (a quoted string) into a field that has a different data type (for example INTEGER). However, the characters that you entered cannot be converted to the type of the field. Consult the operating instructions for this application, then reenter the data.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-2017 fires when a quoted character value entered into a field can't be converted to that
field's actual data type (e.g. INTEGER) — per the official guidance, the characters simply
don't represent a valid value for the target type.
- A character string entered into a field whose type isn't
CHAR, where the string doesn't parse as a valid value for that type, per the official guidance — the direct, only cause.
Solutions / Resolution
- Consult the application's operating instructions and re-enter the data in a format compatible with the target field's data type, per the official guidance.
Examples
N/A
No specific triggering statement is documented — re-enter the value in a format matching the
target field's actual data type (e.g. digits only for an INTEGER field).
Diagnostic Checks
- Check the target field's declared data type, and confirm the entered value is formatted correctly for it.
Related Errors / Related Topics
No closely related error codes are cross-referenced for -2017 in this set yet.
An entered character value doesn't convert to the field's actual data type — re-enter it in a compatible format.