Books
in black and white
Main menu
Share a book About us Home
Books
Biology Business Chemistry Computers Culture Economics Fiction Games Guide History Management Mathematical Medicine Mental Fitnes Physics Psychology Scince Sport Technics
Ads

Teradata RDBMS forUNIX SQL Reference - NCR

NCR Teradata RDBMS forUNIX SQL Reference - NCR, 1997. - 913 p.
Download (direct link): teradataforunix1997.pdf
Previous << 1 .. 225 226 227 228 229 230 < 231 > 232 233 234 235 236 237 .. 241 >> Next

DOS/V CHARSET_TYPE=C CHARSET_ID=119 KANJISJIS_0S

For non-Japanese character sites, no changes are required in the clispb.dat file for UNIX and DOS/V environments.

If a character set has not been user-specified or specified in clispb.dat, then the default is:

the value in the system table, DBC.Hosts

For more information regarding HSHSPB, refer to the appropriate manual listed below.

Teradata Call-Level Interface Version2 for Channel-Attached Systems Teradata Client for MVS Installation Guide Teradata Client for VM Installation Guide

3

If an application relies on the DBC.Hosts table for the default character set name, you must ensure that the initial logon from the IBM (channel-attached) side is in EBCDIC, and for all other platforms, in ASCII; otherwise, the default character set cannot be known to the application before logon

For more information about character sets for UNIX and DOS/V platforms, see previous sections.

G-60

Teradata RDBMS for UNIX SQL Reference
International and Japanese Character Support

Setting Up Japanese Character Support

Teradata RDBMS for UNIX SQL Reference

G-61
International and Japanese Character Support

Setting Up Japanese Character Support

G-62

Teradata RDBMS for UNIX SQL Reference
Japanese Character Sets

Appendix H

Japanese Character Sets

Teradata RDBMS for UNIX SQL Reference
Japanese Character Sets

Teradata RDBMS for UNIX SQL Reference
Japanese Character Sets

About This Appendix

About This Appendix

The text, tables, and figures in this chapter describe the internal and external Japanese character set ranges supported by the Teradata RDBMS, with any combination of IBM, UNIX, and DOS/V client systems.

Teradata RDBMS for UNIX SQL Reference

H-1
Japanese Character Sets

JIS-x0201

JIS-x0201

The Teradata RDBMS uses the JIS-x0201, an 8-bit Japanese standard that defines encoding for 8-bit Latin and Katakana characters. It is used as the encoding for EUC code set 0 and code set 2, and Shift-JIS single byte characters.

The valid ranges for JIS-x0201 characters in KanjiEUC object names can be found in rows cs0 and cs2 in the EUC Code Set Localization table. Note that Katakana symbols 0x82A10x82A5 and Latin symbols other than $, #, andare not allowed.

Figure H-1

The JIS-x0201 Standard

0 1 2 3 4 5 6 7 8 9 A B C D E F
0 SP 0 @ P P 9 -> N
1 ! 1 A Q a q O 7 f-
2 2 B R b r 4V /
3 # 3 C S c s J f* t
4 $ 4 D T d t > X t
5 % 5 E U e u + *- ZL
6 & 6 F V f v I fl - - 3
7 7 G W g w T + J 7
8 ( 8 H X h x I ?'
9 ) 9 I Y i y J Jl
A * : J Z j z X }\ I
B + K [ k { + - h
C < L ? I I t > 7
D = M ] m } . X >
E > N n - '
F / ? O o '7 V

FFAEA012

H-2

Teradata RDBMS for UNIX SQL Reference
Japanese Character Sets

JIS-x0208

JIS-x0208

The JIS-x0208, Japanese Industrial Standard Code for Japanese Graphic Set for Information Exchange is the Japanese double byte Kanji standard.

It has three components, as follows:

JIS non-Kanji contains double byte versions of Latin letters, Katakana, Hiragana, Cyrillic letters, Greek letters, and other special characters that are non-Kanji, like punctuation characters, etc.

JIS I Kanji contains commonly used Kanji characters.

JIS II Kanji contains less commonly used Kanji characters.

Teradata RDBMS for UNIX SQL Reference

H-3
Japanese Character Sets

JIS-x0208

Figure H-2

The JIS-x0208 Standard

00

00

0

.Q

4



21

7E

50

FF

2nd byte

21

7E 80

JIS non-Kanji

JIS I Kanji

JIS II Kanji

FF

FFAEA002

H-4 Teradata RDBMS for UNIX SQL Reference
Japanese Character Sets

IBM Mainframe Character Sets for Japan

IBM Mainframe Character Sets for Japan

The following tables illustrate the EBCDIC for Japan, EBCDIC for Japanese character site, EBCDIC Katakana, EBCDIC Japanese Extended Katakana, EBCDIC Japanese Extended English, and EBCDIC Kanji character sets.

Teradata RDBMS for UNIX SQL Reference

H-5
Japanese Character Sets

IBM EBCDIC Character Set for Japan

IBM EBCDIC Character Set for Japan

The IBM EBCDIC character set for Japan is shown in the following figure.

Figure H-3

IBM EBCDIC Character Set for Japan

0 1 2 3 4 5 6 7 8 9 A B C D E F
0 SP & - { } $ 0
1 / a j A J 1
2 b k s B K S 2
3 c I t C L T 3
4 d m u D M U 4
5 e n v E N V 5
6 f o w F O W 6
7 g P x G P X 7
8 h q y H Q Y 8
9 N i r z I R Z 9
A ? !
B ? #
C < * % @
D ( )
E + > =
F I ?

FFAEA007

H-6

Teradata RDBMS for UNIX SQL Reference
Japanese Character Sets

Non-Kanji EBCDIC Character Set for Japanese Character Site
Previous << 1 .. 225 226 227 228 229 230 < 231 > 232 233 234 235 236 237 .. 241 >> Next