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

When you convert from coded character set identifier (CCSID) 1390 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 that you want to override exists in the conv subdirectory of the sqllib directory, back up that file. Having a backup of the default table allows you to revert back to it, if needed.

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. Activating this alternate Microsoft conversion table does not change the code page conversion behavior of graphic data encoded in 1390 conversion to Unicode.

In addition to the steps in this task, you must move the 1399ucs2.cnv file from the sqllib/conv/ms/ folder to the sqllib/conv/ folder. Moving the file is required when using the alternate Microsoft conversion table to convert graphic data from 1390 encoding to Unicode.

When the procedure is complete, both character data and graphic data are converted to Unicode from the following CCSIDs by using the Microsoft conversion table:
  • 5026
  • 930
  • 1390
  • 5035
  • 939
  • 1399
.

Procedure

To replace the Db2 default conversion table for converting from CCSID 1390 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. Move the file 1390ucs2.cnv from the sqllib/conv/ms folder to the sqllib/conv/ folder.
  3. Restart all applications.