Solved

the encoding configuration of DB2 V8.02

Posted on 2014-10-13
3
449 Views
Last Modified: 2014-11-26
Dear all,

how can I find out the langurage encoding configuration from DB2 V8.02 on Solarix 9 if  I can't putty to it as I am a windows user so I use a lot of UI, I connect by Toad for DB2 v5.6

we would like to see if that DB can store chinese characters.
0
Comment
Question by:marrowyung
  • 2
3 Comments
 
LVL 1

Author Comment

by:marrowyung
ID: 40379080
Administrator, please help to bring me in more DB2 people . tks.
0
 
LVL 45

Accepted Solution

by:
Kent Olsen earned 500 total points
ID: 40379686
HI Marrowyung,

Sorry for the delay in getting back to you.

UDB V8 is very old.  I don't remember the exact details that far back so I'll do the best that my old memory allows.

Connect to your database through the command-line interface and check the db configuration

  db2 connect to mydb
  db2 get db cfg | head -n 12

The results will look something like this:

       Database Configuration for Database

 Database configuration release level                    = 0x0d00
 Database release level                                  = 0x0d00

 Database territory                                      = US
 Database code page                                      = 1208
 Database code set                                       = UTF-8
 Database country/region code                            = 1
 Database collating sequence                             = SYSTEM_1252
 Alternate collating sequence              (ALT_COLLATE) =

Open in new window


That's from my database, which was created with all US defaults.  The most important items in the list are the code page and code set (1208 and UTF-8).

Now check the IBM pages for language support.

  http://www-01.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.admin.nls.doc/doc/r0004565.html

Table 12 contains the list of Chinese translations.  1208/UTF-8 occurs twice in the table.  Once for AIX and once for Solaris.  There is no collation page shown for 1208/UTF-8 for either O/S, suggesting that Chinese is not supported for these systems in 1208/UTF-8.

Kent
0
 
LVL 1

Author Comment

by:marrowyung
ID: 40381385
when I search 'chinese' and it give simplified chinese, I see this line:


1208 N-1 UTF-8 385   HR_HR AIX

it means this 1208 and UTF-8 support simplified chinese, right?

and how can I change it to support both simplified chinese and tranditional chinese?
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
These days, all we hear about hacktivists took down so and so websites and retrieved thousands of user’s data. One of the techniques to get unauthorized access to database is by performing SQL injection. This article is quite lengthy which gives bas…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question