-20286 DB2 CONVERTED STRING token-type tokenFROM from-ccsid TO to-ccsid, AND RESULTED IN SUBSTITUTION CHARACTERS
Explanation
A conversion error occurred during the conversion of a string for token-type token to a different coded character set. One or more substitution characters have been placed in the string during the conversion process.
- token-type
- The type of token.
- token
- The token that was converted.
- from-ccsid
- The coded character set of the string to be converted.
- to-ccsid
- The coded character set to which the string must be converted.
System action
The statement cannot be processed.
Programmer response
Ensure that the data that is provided to Db2 can be converted from from-ccsid to to-ccsid without data loss.
If the -20286 code
was issued during the conversion of security labels, use only security
labels that characters that are not substituted during conversion
from one CCSID to another. For example, the following national characters
might be substituted:
- @ (X'7C')
- # (X'7B')
- $ (X'5B')
SQLSTATE
428GB