Solved

the encoding configuration of DB2 V8.02

Posted on 2014-10-13
3
416 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:
Kdo 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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

CCModeler offers a way to enter basic information like entities, attributes and relationships and export them as yEd or erviz diagram. It also can import existing Access or SQL Server tables with relationships.
Many companies are looking to get out of the datacenter business and to services like Microsoft Azure to provide Infrastructure as a Service (IaaS) solutions for legacy client server workloads, rather than continuing to make capital investments in h…
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…

707 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now