Informix Error -23114
Cause and resolution
Place holder for GCV truncation.
During code-set conversion of tuple data, if the output buffer is not large enough to hold the result of a code-set conversion, and the resultant string could not be truncated into the available buffer successfully, this error is returned. This error occurs in the SQL interface layer between the application program and the database server. Increase the size of the host variable that will hold the possibly expanded string that is returned after code-set conversion from a SELECT or FETCH statement.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-23114 fires when tuple-data code-set conversion's output buffer isn't large enough to hold the converted result, and the result couldn't be successfully truncated to fit — per the official guidance, this occurs in the SQL interface layer between the application and the database server.
- The output buffer being too small for the converted result, with truncation also failing, per the official guidance — the direct, only cause.
Solutions / Resolution
- Increase the size of the host variable holding the possibly-expanded string
returned from a
SELECT/FETCH, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond an output buffer too small even for truncation.
Diagnostic Checks
- Check the size of the host variable receiving the converted result, and increase it to accommodate the code-set-expanded string.
Related Errors / Related Topics
No closely related error codes are cross-referenced for -23114 in this set yet.
A code-set conversion's output buffer was too small even to truncate the result into — increase the receiving host variable's size.