When character data is transferred between machines, it must be converted to a form that the receiving machine can use.
For example, when data is transferred between the DB2 Connect workstation and a DRDA server, it is usually converted from a workstation code page to a host CCSID, and vice versa. If the two machines use different code pages or CCSIDs, code points are mapped from one code page or CCSID to the other. This conversion is always performed at the receiver.
Character data sent to a database consists of SQL statements and input data. Character data sent from a database consists of output data. Output data that is interpreted as bit data (for example, data from a column declared with the FOR BIT DATA clause) is not converted. Otherwise all input and output character data is converted if the two machines have different code pages or CCSIDs.
For example, if DB2 Connect is used to access DB2 for OS/390 or DB2/MVS data, the following happens:
The table that follows shows the conversions that are supported between code pages (on the workstation) and CCSIDs (on the host).
For more detailed information about supported code page conversions, refer
to the Administration Guide.
Table 11. Workstation Code Page to Host CCSID Conversion
| Host CCSIDs | Code Page | Countries |
|---|---|---|
| 037, 273, 277, 278, 280, 284, 285, 297, 500, 871 | 437, 819, 850, 860, 863, 1004, 1051, 1252, 1275 | Australia, Austria, Belgium, Brazil, Canada, Denmark, Finland, France, Germany, Iceland, Italy, Latin America, Netherlands, New Zealand, Norway, Portugal, South Africa, Spain, Sweden, Switzerland, UK, USA |
| 875, 423 | 813, 869, 1253, 1280 | Greece |
| 870 | 852, 912, 1250, 1282 | Croatia, Czech Republic, Hungary, Poland, Romania, Serbia/Montenegro (Latin), Slovakia, Slovenia |
| 1025 | 855, 915, 1251, 1283 | Bulgaria, FYR Macedonia, Serbia/Montenegro (Cyrillic) |
| 1026 | 857, 920, 1254, 1281 | Turkey |
| 424 | 862, 916, 1255 | Israel |
| 420 | 864, 1046, 1089, 1256 | Arabic countries |
| 1025 | 866, 915, 1251, 1283 | Russia |
| 838 | 874 | Thailand |
| 930, 939, 1027, 5026, 5035 | 932, 942, 943, 954, 5039 | Japan |
| 937 | 938, 948, 950, 964 | Taiwan |
| 933 | 949, 970, 1363 | Korea |
| 935 | 1381, 1383 | People's Republic of China |
Note that code page 1004 is supported as code page 1252.
In general, data can be converted from a code page to a CCSID and back again to the same code page with no change. The following are the only exceptions to that rule: