Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2002

    Unanswered: Multilingual Support

    How does DB2 multilingual support work? Is it installation specific or a database specific setting? Is there a way to check if a current installation supports multilingual data?


  2. #2
    Join Date
    Jun 2006


    does this not mean that data is save in different codepages ?
    sysibm.syscolumns keeps codepage for each character field and if clients with different codepage come in and create their tables you will have data with different codepage origine. Or if having an utf database and using graphic fields, you could save data for different languages. will have a lookup on this.
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

  3. #3
    Join Date
    Jun 2006


    according the infocenter, this means that db2 has been installed with multi languages (english and other..) changing the default system language will return the messages in that language if previously installed. It is an installation issue and copying the language repositories that have been specified instead of default english.
    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

  4. #4
    Join Date
    May 2003
    There are 2 main kinds of multi-lingual support:

    1. Multiple languages with a single-byte character set (English, Italian, German, French, Brazilian Portuguese, Spanish, etc).

    2. Supporting languages that require double-byte character sets such as Japanese, Korean, Simplified Chinese, Traditional Chinese (This version also supports single byte character sets).

    DB2 Install Code
    Some versions (like Linux and Windows) are language independent and have only one install (or fixpack) install code. AIX has a separate instal code (and separate fixpacks) depending on whether you want option 1 or 2 above. You can check the fixpack page for more details about your specific platform.

    Enabling Double Byte Character Support at the Database Level
    Double byte character support is usually enabled at the database level by specifying UTF-8 Codeset when creating the database:
    The territory code only affects the default of built-in client on the server and does not affect the ability to support multiple languages in the database server.

    Column Considerations for Double-Byte Support
    When storing "double-byte" characters in a UTF-8 database, you should allow for column lengths that are about 3 times the normal length (this is only necessary if you actually store Japanese, Korean, Simplified Chinese, Traditional Chinese characters in a column). Unfortunately, the amount of space needed varies by character, and cannot be exactly determined in advance. For this reason, you should normally use VARCHAR for columns that can have both single and double-byte characters in them (such as English and Japanese).

    Enabling Double-Byte Support at the Table Level
    You can enable double-byte character sets at the table level (on a non UTF-8 database) by specifying UNICODE when creating the table, but there are some extreme limitations that usually make this impractical (see the UNICODE parameter in CREATE TABLE in the SQL Reference Vol. 2).
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts