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

Teradata RDBMS forUNIX SQL Reference - NCR

NCR Teradata RDBMS forUNIX SQL Reference - NCR, 1997. - 913 p.
Download (direct link): teradataforunix1997.pdf
Previous << 1 .. 207 208 209 210 211 212 < 213 > 214 215 216 217 218 219 .. 241 >> Next

Teradata RDBMS for UNIX SQL Reference
International Character Support

Teradata RDBMS for UNIX SQL Reference
International and Japanese Character Support

About This Appendix

About This Appendix

This appendix covers the following topics:

• Introduction

• Defining character sets

• External to internal, lowercase and uppercase translations

• Creating and implementing character sets

• User-defined character set restrictions (EBCDIC,ASCII)

• Alternative currency symbols

• Naming user-defined Kanji character sets

• Considerations for defining Kanji character sets

• Columns in DBC.CharTranslations view

• Inserting codes into DBC.CharTranslations view

• Loading rows into DBC.HostsInfo view

• Example of inserting the Swedish character set into DBC.CharTranslations

• Assigning client defaults through DBC.HostsInfo view

• Installing character sets

• Teradata internal form of international character support (table)

• Using Collation Sequences

• Two-level collations: Teradata standard multinational

• Single-level collations: Japanese language

• Tools for collation control

• Changing the standard multinational default collation

• De-installing a non-standard collation

• Example of de-installing/installing a kanji standard collation

• Defining your own collation sequence

• Example of inserting and installing a user-defined collation sequence

• Changing a user-defined default

Teradata RDBMS for UNIX SQL Reference

International and Japanese Character Support

About This Appendix

• Japanese character support

• Using Kanji characters

• IBM-compatible character sets

• UNIX-compatible character set (KanjiEUC_0U)

• DOS/V-compatible character set (KanjiShift-JIS_0S)

• Kanji translation and storage

• Accessing and sharing Kanji objects and data

• Japanese character sites

• Setting up Japanese character support for channel-attached and network-attached systems


Teradata RDBMS for UNIX SQL Reference
International and Japanese Character Support



Character Sets


Teradata RDBMS supports English language data characters, and selected international or Japanese data characters.

• The International Character Support feature enables the insertion, retrieval, and sort ordering of data characters containing diacritical marks, such as a and n.

• The Japanese Character Support feature supports object names and data containing Kanji ideographs, Katakana, Hiragana and various other characters. It enables the insertion and retrieval of character and graphic data in Japanese.

With either feature, the system administrator can define and install new external character set representations and redefine and reinstall the MULTINATIONAL collation. Users can control at the session level both the character set to be used for external representation and the collation sequence to be used for sort ordering and comparison operations.

During any session, use the HELP SESSION statement to display the character set and collation currently in effect.


The ASCII code mentioned in this appendix is based on Standard ASCII, but includes some Teradata extensions. See Table G-1,

“Supported Multinational Characters” for International Character support, and for Japanese Character support.

EBCDIC mentioned in this manual, refers to a similar Teradata Extended EBCDIC.

If you do not define your own character sets, then the default for the external representation of data is EBCDIC for channel-attached client (host) systems and ASCII for all other clients.

If you choose to define character sets, you can assign the set to be used as the default for a particular client system.

At the session level, you can override the client default by submitting (if using BTEQ) a [. SET] SESSION CHARSET charsetname statement.

Teradata RDBMS for UNIX SQL Reference

International and Japanese Character Support


Collation Sequences

Hashing Considerations

The default collation sequence is based upon the client type:

• EBCDIC, for channel-attached clients

• ASCII, for all other clients

Collation can be set at the user level in the CREATE/MODIFY USER statement, or at the session level (if using BTEQ) with the [.SET] SESSION COLLATION statement.

When collation is set to MULTINATIONAL, the default sequence currently installed is used. This can be one of the pre-defined sequences supplied with the Teradata RDBMS, or a sequence you have defined and installed.

The pre-defined collation sequence options are:

• Teradata Standard Multinational (the initial default)

• Swedish

• Norwegian

• Katakana_Standard

• Kanji5026_Standard

• Kanji5035_Standard

You can execute pre-defined macros to change the default to Swedish, Norwegian, or the appropriate Japanese standard collation.

Alternatively, you can define and install a different sequence, as explained later in this chapter.
Previous << 1 .. 207 208 209 210 211 212 < 213 > 214 215 216 217 218 219 .. 241 >> Next