View Single Post

   
  #1 (permalink)  
Old 02-26-2008, 05:38 PM
Kanv
 
Posts: n/a
Default Language Settings for DB2 UDB 8.1

Hi,

I am setting up a database which requires some tables to store Thai
language data, as well as English data. For this, during the DB
creation of the test database, I set the following properties for the
DB:
-Database territory= TH
-Database code set= UTF-8
and DB2 set these values by default:
-Database code page= 1208
-Database country/region code= 66

After this, I inserted values into the column but the DB seems to
store and return junk values. I need to find out fast what values I
should set during the create db process to be able to support Thai and
English data.

The create db statement takes in the following params, for which I
need to set the correct values:
-CODESET
-CODEPAGE
-NLS CHAR SET
-COLLATE COMPATIBILITY
-IDENTITY
-IDENTITY_16BIT

Desperatly Seeking GURU!

Thanks in advance.

kP
Reply With Quote