Solved

the encoding configuration of DB2 V8.02

Posted on 2014-10-13
3
457 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 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Error 438 6 52
Creating a View from a CTE 15 46
Oracle SQL-Queries on a RAC Database 3 45
Zip Codes Excel Spreadsheet 4 24
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.
Creating and Managing Databases with phpMyAdmin in cPanel.
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…

734 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