Informix Error -79742: Can't convert from.
Cause and resolution
Can't convert from.
No data conversion is possible from the data type you specified to the column data type. The actual data type is appended to the end of this message.
Check your program logic to make sure that the conversion you asked for is supported. For the data mapping matrix, see the Informix JDBC Driver Driver Programmer's Guide.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-79742 fires when no data conversion is possible from a specified data type to the column's data type — per the official guidance, the actual data type is appended to the message text.
- A requested conversion to the column's actual data type not being supported, per the official guidance — the direct, only cause.
Solutions / Resolution
- Check the program logic to confirm the conversion is supported, per the official guidance, checking the data-mapping matrix in the Informix JDBC Driver Programmer's Guide.
Examples
N/A
No specific triggering statement is documented beyond an unsupported from-conversion; the message text names the actual data type.
Diagnostic Checks
- Check the requested conversion against the Programmer's Guide's data-mapping matrix.
Related Errors / Related Topics
- -79741 — "Can't convert to." The mirror-image conversion error, converting the column's type to a requested type rather than a specified type to the column's type.
An unsupported conversion to the column's data type was requested — check the Programmer's Guide's data-mapping matrix.