The character code-set conversion failed while converting a character string from the code set that from-cs-num identifies to the code set that to-cs-num identifies.
cftype The conversion failure type.
from_cs_num The code-set number for the input code set. Check your IBM Informix product documentation for a description of the code set that this code-set number identifies.
objtype The type of object that is being converted.
position The ordinal position of the value that is being converted.
to_cs_num The code-set number for the output code set. Check your IBM Informix product documentation for a description of the code set that this code-set number identifies.
The following are the possible cftype values:
* If cftype is "unmapped input char" (cpstring), the input character did not exist in the output code set, and the conversion table did not define a substitute output character for the input character. The cpstring value shows the input character string for a length of up to 4 bytes, starting with the codepoint that could not be converted. The binary value of the codepoint bytes is represented by cpstring as a hexadecimal string (for example, 'c1c3d1f0').
This failure type has two possible causes:
1. The character data that is being converted is bad. Correct the character data that is being converted.
2. The code-set conversion table is incorrect or incomplete. Contact your IBM Informix software distributor for assistance.
* If cftype is "bad form," the input character string was badly formed with respect to the shift-out and shift-in codepoints that delimit the internal code sets that are contained within the code set that code-set number from_cs_num identifies.
For this failure type, correct the form of character data that is being converted.
* If cftype is "too long," the length of the output string was longer than the internal buffers that are allocated to hold the output string. If the objtype is "output," the output value was longer than the maximum length of a CHAR data type.
For this failure type, shorten the input character data that is being converted.
The following are the possible objtype values:
* If objtype is "input," an input value from the application, such as an SQL statement or an input host variable value, was being converted.
* If objtype is "output," an output value from the database, such as a field or expression from the select list of a SELECT statement, was being converted.
* If objtype is "sqlda," an sqlname field in the output SQLDA was being converted.
* If objtype is "sqlca," a character field in the SQLCA was being converted.
The following possible meanings of position depend on the value of objtype:
* If objtype is "input" and position is 0, the text of the input SQL statement could not be converted.
* If objtype is "input" and position is not 0, position refers to the ordinal position of the input host variable value that could not be converted. For example, 2 means that the value of the second input host variable could not be converted.
* If objtype is "output" and position is any value, position is the ordinal position of the output value that could not be converted, such as the third value in the select list of a SELECT statement.
* If objtype is "sqlda" and position is any value, position is the ordinal position of the sqlname field in the SQLDA that could not be converted.
* If objtype is "sqlca," position names the specific SQLCA field that could not be converted: sqlerrp, sqlwarn, sqlerrmc, or sqlstate.