Oninit
Talk to an expert →

Informix Error -79741: Can't convert to.

Cause and resolution

Can't convert to.

No data conversion is possible from the column data type to the one specified. The actual data type is appended to the end of this message.

Review 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

-79741 fires when no data conversion is possible from a column's data type to the type requested — per the official guidance, the actual data type is appended to the message text.

  1. A requested conversion from the column's actual data type not being supported, per the official guidance — the direct, only cause.
Solutions / Resolution
  1. Review 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 to-conversion; the message text names the actual data type.

Diagnostic Checks
  1. Check the requested conversion against the Programmer's Guide's data-mapping matrix.
Related Errors / Related Topics
  • -79742 — "Can't convert from." The mirror-image conversion error, converting a specified type to the column's type rather than the column's type to a requested type.

An unsupported conversion from the column's data type was requested — check the Programmer's Guide's data-mapping matrix.