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

When you convert from coded character set identifier (CCSID) 1399 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.

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 uses the Microsoft conversion table:
  • 930
  • 1390
  • 5035
  • 939
  • 1399

Procedure

To replace the Db2 default conversion table for converting from CCSID 1399 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.