?
Solved

the encoding configuration of DB2 V8.02

Posted on 2014-10-13
3
Medium Priority
?
486 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 1

Author Comment

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

Accepted Solution

by:
Kent Olsen earned 2000 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

Get proactive database performance tuning online

At Percona’s web store you can order full Percona Database Performance Audit in minutes. Find out the health of your database, and how to improve it. Pay online with a credit card. Improve your database performance now!

Question has a verified solution.

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

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
In this article, we’ll look at how to deploy ProxySQL.
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

762 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