Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557

    Unanswered: Multi language in 1 db

    I was asked to look into can it be done and what needs to be done to be able to store English and Polish in our current DB. Here are the setting that we have now

    Database territory = US
    Database code page = 819
    Database code set = ISO8859-1
    Database country/region code = 1

    Informational tokens are "DB2 v8.1.0.144", "s080111", "U811680", and FixPak
    "16".

    From what I have read looks like in order to resolve this problem db would have to rebuild using code page 1208, Group N-1, Code set UTF-8.

    Territory code for English is 1 and Polish is 48. What do I set it in a new DB?
    Or as long as it is Unicode we are ok not setting Territory and Locale?

    Am I at least on the right track? Any words of wisdom would be appreciated.

    Thank you. Alex
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    the only setting that is really important is the code set utf-8
    when storing multiple languages in same db think also of defining graphic instead of char fields, because 5 characters may not fit in a char(5) column
    use graphic(5) or vargraphic instead
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    Thanks Guy!!!

    Follow up question which I should have asked originally and most likely know the answer already but still.

    The only way to move data from current db to a new UTF-8 is to unload and reload. Correct? Anything funky in the unload/load command that I should be aware of. Looked at the manual and can't really see anything different. This is a peoplesoft db with tons of tables.

    Thank you again.
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

Posting Permissions

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