Appendix E. Coded character set identifiers (CCSIDs) in
Query for iSeries
This appendix contains information about coded character set identifiers or CCSIDs. This information will
help you understand CCSIDs and why they are important to Query for iSeries.
A
CCSID
is a 2-byte (unsigned) integer that uniquely identifies an encoding scheme and one or more pairs
of character sets and code pages. A CCSID can be assigned to each query definition, data field, and
collating sequence. A CCSID can also be assigned to individual items in a file record format definition,
such as the column heading, text description, edit word, or long comment for a field.
CCSID-marked data can be converted so that it looks the same in languages that use the same character
set or superset of the character set (see Figure 7 on page 246). Data will not look the same without
conversion if the code pages differ. The hexadecimal value for a graphic character (a character that is
displayed or printed) in one language may be different than the value for the equivalent character in
another language. The problem does not end with displaying and printing. If data is collated using a
sequence prepared from characters in a different code page, or if data in different code pages is
compared without being converted, the result will seem incorrect.
© Copyright IBM Corp. 2000, 2002
245
Summary of Contents for ISERIES SC41-5210-04
Page 1: ...iSeries Query for iSeries Use Version 5 SC41 5210 04 ERserver ...
Page 2: ......
Page 3: ...iSeries Query for iSeries Use Version 5 SC41 5210 04 ERserver ...
Page 12: ...x Query for iSeries Use V5R2 ...
Page 14: ...2 Query for iSeries Use V5R2 ...
Page 32: ...20 Query for iSeries Use V5R2 ...
Page 38: ...26 Query for iSeries Use V5R2 ...
Page 44: ...32 Query for iSeries Use V5R2 ...
Page 116: ...104 Query for iSeries Use V5R2 ...
Page 122: ...110 Query for iSeries Use V5R2 ...
Page 146: ...134 Query for iSeries Use V5R2 ...
Page 150: ...138 Query for iSeries Use V5R2 ...
Page 174: ...162 Query for iSeries Use V5R2 ...
Page 178: ...166 Query for iSeries Use V5R2 ...
Page 196: ...184 Query for iSeries Use V5R2 ...
Page 198: ...186 Query for iSeries Use V5R2 ...
Page 204: ...192 Query for iSeries Use V5R2 ...
Page 205: ...Part 4 Appendixes Copyright IBM Corp 2000 2002 193 ...
Page 206: ...194 Query for iSeries Use V5R2 ...
Page 210: ...198 Query for iSeries Use V5R2 ...
Page 242: ...230 Query for iSeries Use V5R2 ...
Page 256: ...244 Query for iSeries Use V5R2 ...
Page 270: ...258 Query for iSeries Use V5R2 ...
Page 272: ...260 Query for iSeries Use V5R2 ...
Page 292: ...280 Query for iSeries Use V5R2 ...
Page 293: ......
Page 294: ... Printed in U S A SC41 5210 04 ...