DB2 are packaged with different translated version. E.g. For the Asian
market, you will get a CD in Chinese and English. The translated version
only provide the translated documentations, messages and help. However, the
internal language support are the same.
If you just want to support 1 second language and English, you can create a
database in that second language. English is always available in any code
page. E.g. If you want to support Japanese and English in your database,
you can create a IBM-943 database. However, there are two written Chinese:
Simplified Chinese and Traditional Chinese. The encoding are different for
them. If you want to support Simplified Chinese and Traditional Chinese at
the same time, you need to create a Unicode database.Please refer to DB2
Administration Guide: National Language Support for the list of supported
On AIX, you need to install the fonts and locales in order to see and type
Japanese or Chinese characters. Without those filesets, the Chinese or
Japanese character looks like garbage on the screen. Or actually you cannot
even open a Chinese/Japanese x terminal without the basic language OS
> Dear all,
> I would like to ask if I want to have a database that the primary language
> is English but it can support to store more than 1 second languges (eg,
> chinese japaness etc), is it I can just install the corresponding language
> DB2 code-page file set is ok. If so, what code-page should if specify when
> creating the database.
> Also, apart for the DB2 code-page file set, do I need to install the
> language code-page to the OS in order for DB2 to support multi-language ?
> I am using DB2 v7.2 on AIX 4.3.3
> Thanks !