Multicultural support and SQL statements
The coding of SQL statements is not language dependent. The SQL keywords must be typed as shown, although they may be typed in uppercase, lowercase, or mixed case. The names of database objects, host variables and program labels that occur in an SQL statement must be characters supported by your application code page.
The server does not convert file names. To code a file name, either use the ASCII invariant set, or provide the path in the hexadecimal values that are physically stored in the file system.
- The double-byte percentage and double-byte underscore characters used in LIKE processing.
- The double-byte space character used for blank padding in graphic strings and in other places.
- The double-byte substitution character, used as a replacement during code page conversion when no mapping exists between a source code page and a target code page.
The code points for each of these characters, by code page, is as follows:
| Code Page | Double-Byte Percentage | Double-Byte Underscore | Double-Byte Space | Double-Byte Substitution Character |
|---|---|---|---|---|
| 932 | X'8193' | X'8151' | X'8140' | X'FCFC' |
| 938 | X'8193' | X'8151' | X'8140' | X'FCFC' |
| 942 | X'8193' | X'8151' | X'8140' | X'FCFC' |
| 943 | X'8193' | X'8151' | X'8140' | X'FCFC' |
| 948 | X'8193' | X'8151' | X'8140' | X'FCFC' |
| 949 | X'A3A5' | X'A3DF' | X'A1A1' | X'AFFE' |
| 950 | X'A248' | X'A1C4' | X'A140' | X'C8FE' |
| 954 | X'A1F3' | X'A1B2' | X'A1A1' | X'F4FE' |
| 964 | X'A2E8' | X'A2A5' | X'A1A1' | X'FDFE' |
| 970 | X'A3A5' | X'A3DF' | X'A1A1' | X'AFFE' |
| 1381 | X'A3A5' | X'A3DF' | X'A1A1' | X'FEFE' |
| 1383 | X'A3A5' | X'A3DF' | X'A1A1' | X'A1A1' |
| 13488 | X'FF05' | X'FF3F' | X'3000' | X'FFFD' |
| 1363 | X'A3A5' | X'A3DF' | X'A1A1' | X'A1E0' |
| 1386 | X'A3A5' | X'A3DF' | X'A1A1' | X'FEFE' |
| 5039 | X'8193' | X'8151' | X'8140' | X'FCFC' |
| 1392 | X'A3A5' | X'A3DF' | - | - |
Code Page 5488 is equivalent to 1392 for the EXPORT, IMPORT, and LOAD utilities.
For Unicode databases, the GRAPHIC space is X'0020', which is different from the GRAPHIC space of X'3000' used for eucJP (Extended UNIX Code - Japan) and eucTW (Extended UNIX Code - Taiwan) databases.
Both X'0020' and X'3000' are space characters in the Unicode standard. The difference in the GRAPHIC space code points should be taken into consideration when comparing data from these EUC databases to data from a Unicode database.