Filter
Top Products
Query for iSeries recognizes when conversion of data, collating sequences, and text is needed, and
performs the conversion. The system notifies you if the conversion fails. You may not be able to work on a
query or run a saved query depending on the CCSIDs involved. Four conditions can result from CCSID
comparisons:
v They match identically, which means no conversion is necessary.
v They are compatible, which means complete conversion is possible.
v They are compatible with substitution, which means conversion is possible but substitution characters
might be used. Substitution characters, depending on where they occur, can give unpredictable results,
particularly in sorting and testing character fields.
v They are incompatible, which means conversion is impossible.
This appendix explains how CCSIDs affect what Query for iSeries does in specific circumstances. For
more information, see the Query for iSeries section of the National Language Support topic.
Figure 7. Working with and without CCSID Conversion. Conversion, when necessary and possible, is done
automatically by the system.
246 Query for iSeries Use V5R2