Code point differences between EBCDIC CCSIDs
Although many EBCDIC code pages are similar, code points for certain characters vary from code page to code page. These characters are called variant characters and can potentially cause problems.
Characters A-Z, a-z, and 0-9 correspond to the same hexadecimal code points on most EBCDIC code pages. Other characters, such as the left bracket ([) correspond to different code points depending on the CCSID. Therefore, to ensure that DB2® interprets your data correctly, you should specify the correct CCSID, especially when you use characters other than A-Z, a-z, and 0-9.
The following tables show some code point differences between several common EBCDIC CCSIDs.
The following table shows the difference in code points between EBCDIC CCSID 37 and EBCDIC CCSID 500.
| Code point | Character | |
|---|---|---|
| CCSID 37 | CCSID 500 | |
| X'4A' | ¢ (cent sign) | [ (left bracket) |
| X'4F' | | (vertical bar) | ! (exclamation point) |
| X'5A' | ! (exclamation point) | ] (right bracket) |
| X'5F' | ¬(logical not) | ˆ (circumflex accent) |
| X'B0' | ˆ(circumflex accent) | ¢ (cent sign) |
| X'BA' | [ (left bracket) | ¬(logical not) |
| X'BB' | ] (right bracket) | | (vertical bar) |
The following table shows the difference in code points between EBCDIC CCSID 37 and EBCDIC CCSID 1047.
| Code point | Character | |
|---|---|---|
| CCSID 37 | CCSID 1047 | |
| X'5F' | ¬(logical not) | ˆ(circumflex accent) |
| X'AD' | Ý (uppercase Y with acute accent) | [ (left bracket) |
| X'B0' | ˆ(circumflex accent) | ¬(logical not) |
| X'BA' | [ (left bracket) | Ý (uppercase Y with acute accent) |
| X'BB' | ] (right bracket) | ¨ (umlaut) |
| X'BD' | ¨ (umlaut) | ] (right bracket) |
The following table shows the difference in code points between EBCDIC CCSID 500 and EBCDIC CCSID 1047.
| Code point | Character | |
|---|---|---|
| CCSID 500 | CCSID 1047 | |
| X'4A' | [ (left bracket) | ¢(cent sign) |
| X'4F' | ! (exclamation point) | | (vertical bar) |
| X'5A' | ] (right bracket) | ! (exclamation point) |
| X'AD' | Ý (uppercase Y with acute accent) | [ (left bracket) |
| X'B0' | ¢(cent sign) | ¬(logical not) |
| X'BA' | ¬(logical not) | Ý (uppercase Y with acute accent) |
| X'BB' | | (vertical bar) | ¨ (umlaut) |
| X'BD' | ¨ (umlaut) | ] (right bracket) |