DB2 Version 9.7 for Linux, UNIX, and Windows

FP1: GB18030 code set support has been extended

Starting with DB2 V9.7 Fix Pack 1, code page 1392 (GB18030) is supported as a client and database code page. Prior to this release, code page 1392 could only be used with the EXPORT, IMPORT, and LOAD utilities with a Unicode database.

To create a database with GB18030 code set, use the following command:

CREATE DATABASE ... USING CODESET GB18030 TERRITORY CN

You can connect to databases with GB18030 data from clients that either use code page 1392 or Unicode code page 1208 as the application code page.

Windows operating systems do not have a locale setting that reports GB18030 as the code set. To ensure that a DB2® client treats a Windows workstation as using the GB18030 code set (code page 1392), complete the following tasks:

Install the GB18030 Support Package, which is available from Microsoft.
In the Regional and Language Options, set the Language for non-Unicode programs setting to Chinese PRC.
Set the DB2CODEPAGE registry variable to 1392.

File names with characters in the GB18030 code set but not in the GBK code set are not supported in the deprecated Control Center. To open or save these files, use CLP commands or CLI.