Windows clients connecting to code page 950 databases

Starting in Db2® Version 9.5, Windows clients that have installed the Microsoft Hong Kong Supplementary Character Set 2001 (HKSCS-2001) package will no longer be able to connect to code page 950 databases by default.

The Microsoft HKSCS-2001 package changes the internal code page of the client to 1375, but reports the code page of the client as 950.

The Db2 client detects whether this package is installed on the Windows workstation. If it is installed, the Db2 client treats the Windows workstation as code page 1375. To allow a Windows Db2 client to connect to a code page 950 database, set the DB2CODEPAGE registry variable to 950 on the Windows client, by issuing the db2set DB2CODEPAGE=950 command.

If you have multiple Windows clients, you must set the DB2CODEPAGE registry variable on all of your clients.

If you set DB2CODEPAGE registry variable at the instance level on a client, it affects all applications running on that client. Applications must be restarted for the DB2CODEPAGE setting to take effect.

For more information about the HKSCS, see the Government of the Hong Kong Special Administrative Region website at http://www.info.gov.hk/digital21/eng/hkscs/. For more information about the Microsoft HKSCS-2001 package, see http://www.microsoft.com/hk/hkscs/.