IBM Books

Quick Beginnings for UNIX


Conversion of Character Data

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 host or AS/400 database 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 Universal Database for OS/390 or DB2/MVS data, the following happens:

  1. DB2 Connect sends an SQL statement and input data to OS/390 or MVS.

  2. DB2 Universal Database for OS/390 converts the data to an EBCDIC CCSID and processes it.

  3. DB2 Universal Database for OS/390 sends the result back to the DB2 Connect workstation.

  4. DB2 Connect converts the result to an ASCII or ISO code page and returns it to the user.

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 24. Workstation Code Page to Host CCSID Conversion
Host CCSIDs Code Page Countries
037, 273, 277, 278, 280, 284, 285, 297, 500, 871, 1140-1149 437, 819, 850, 858, 860, 863, 1004, 1051, 1252, 1275 Albania, Australia, Austria, Belgium, Brazil, Canada, Denmark, Finland, France, Germany, Iceland, Ireland, Italy, Latin America, Netherlands, New Zealand, Norway, Portugal, South Africa, Spain, Sweden, Switzerland, UK, USA
423, 875 737, 813, 869, 1253, 1280 Greece
870 852, 912, 1250, 1282 Croatia, Czech Republic, Hungary, Poland, Romania, Serbia/Montenegro (Latin), Slovakia, Slovenia
1025 855, 866, 915, 1251, 1283 Bulgaria, FYR Macedonia, Russia, Serbia/Montenegro (Cyrillic)
1026 857, 920, 1254, 1281 Turkey
424 862, 916, 1255 Israel - see note 3 below
420 864, 1046, 1089, 1256 Arabic countries - see note 3 below
838 874 Thailand
930, 939, 5026, 5035 932, 942, 943, 954, 5039 Japan
937 938, 948, 950, 964 Taiwan
933, 1364 949, 970, 1363 Korea
935, 1388 1381, 1383, 1386 People's Republic of China
1112, 1122 921, 922 Estonia, Latvia, Lithuania
1025 915, 1131, 1251, 1283 Belarus
1123 1124, 1125, 1251 Ukraine

Notes:

  1. Code page 1004 is supported as code page 1252.

  2. 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:

  3. For bidirectional languages, a number of special "BiDi CCSIDS" have been defined by IBM and are supported by DB2 Connect Version 6.

    If the bidirectional attributes of the database server are different from those of the client you can use these special CCSIDS to manage the difference.

    Refer to the Administration Guide for details of these special CCSIDs. Refer to the Release Notes for DB2 Connect Version 6 for detailed information about how to set them up for DRDA host connections.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]