Replacing the Unicode conversion table for CCSID 5035 with the Microsoft conversion table

When you convert from coded character set identifier (CCSID) 5035 to Unicode, the Db2® database manager default code page conversion table is used. If you want to use a different version of the conversion table such as the Microsoft version, you must manually override the default conversion table.

Before you begin

If the code page conversion table file you want to override exists in the conv subdirectory of the sqllib directory, back up that file in case you want to revert to the default table.

About this task

For conversion table replacement to be effective, every Db2 client that connects to the same database must have its conversion table changed.

This Microsoft conversion table is only for data encoded in CCSID 5039 or 939, and cannot be used for data encoded in CCSID 1399. Since the Db2 database manager uses the same conversion table for data encoded in CCSIDs 5035, 939, and 1399, this means that once the default IBM conversion table has been replaced with the Microsoft conversion table, you should not select any data that is encoded in CCSID 1399.

Once you have replaced the default IBM conversion table with the Microsoft conversion table, the conversion of graphic data to Unicode from the following CCSIDs will also use this Microsoft conversion table: 930, 1390, 939, and 1399.

Procedure

To replace the Db2 default conversion table for converting from CCSID 5035 to Unicode:

  1. When replacing conversion tables on the client, stop all the applications that are using the database.
    If you have any CLP sessions running, issue the TERMINATE command for each session.
  2. Copy sqllib/conv/ms/0939ucs2.cnv to sqllib/conv/1399ucs2.cnv.
  3. Restart all the applications.