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 .. 219 220 221 222 223 224 < 225 > 226 227 228 229 230 231 .. 241 >> Next

|'DDDEDFE0F8E1E2E3F9E4E5E6E7E8FAE9 xb /* B */
|'6161616161AEAB636565656569696969 xb /* C */
|'FC6E6F6F6F6F6F6FAC757575757 9FB73 xb /* D */
|'6161616161AEAB636565656569696969 xb /* E */
|'FD6E6F6F6F6F6F6FAC7575757579FEFF xb /* F */

/* CollOrderCS. Case-specific ordering */
/* 0 1 2 3 4 5 6 7 8 9 A B C D E F */
, 00000000000000000000000000000000' xb /* 0 */
|L 00000000000000000000000000000000' xb /* 1 */
|L 00000000000000000000000000000000' xb /* 2 */
|L 00000000000000000000000000000000' xb /* 3 */
|L 00010101010101010101010101010101' xb /* 4 */

The following example illustrates a BTEQ batch job that inserts into the DBC.Collations view a 256-character row containing the hex codes for a user-defined collation sequence, and then executes the CollInstallMulti macro to insert those codes as the new default.

Teradata RDBMS for UNIX SQL Reference

G-37
International and Japanese Character Support

Defining Your Own Collation Sequence

|'01010101010101010101010000000000 'xb /* 5 */
|'00000000000000000000000000000000 'xb /* 6 */
|'00000000000000000000000000000000 'xb /* 7 */
|'00000000000000000000000000000000 'xb /* 8 */
|'00000000000000000000000000000000 'xb /* 9 */
|'00000000000000000000000000000000 'xb /* A */
|'00000000000000000000000000000000 'xb /* B */
|'03050709 0B0101030305070903050709 'xb /* C */
|'000303050709 0B0D0103050709030002 'xb /* D */
|'02 04 06 080A000002 02 04 06 0802 04 06 08 'xb /* E */
|'0002 02 04 06 080A0C0002 04 06 0802 0000 'xb /* F */
* CollOrderUC. uppercase ordering */
* 0 1 2 3 4 5 6 7 8 9 A B C D E F */
'00000000000000000000000000000000 'xb /* 0 */
|'00000000000000000000000000000000 'xb /* 1 */
|'00000000000000000000000000000000 'xb /* 2 */
|'00000000000000000000000000000000 'xb /* 3 */
|'00010101010101010101010101010101 'xb /* 4 */
|'01010101010101010101010000000000 'xb /* 5 */
|'00010101010101010101010101010101 'xb /* 6 */
|'01010101010101010101010000000000 'xb /* 7 */
|'00000000000000000000000000000000 'xb /* 8 */
|'00000000000000000000000000000000 'xb /* 9 */
|'00000000000000000000000000000000 'xb /* A */
|'00000000000000000000000000000000 'xb /* B */
|'03050709 0B0101030305070903050709 'xb /* C */
|'000303050709 0B0D0503050709030001 'xb /* D */
|'03050709 0B0101030305070903050709 'xb /* E */
|'000303050709 0B0D0503050709030001 'xb /* F */)

/*

* Now install this collation as the collation default */

EXECUTE CollInstallMulti ('NON_STANDARD');

G-38

Teradata RDBMS for UNIX SQL Reference
International and Japanese Character Support

Defining Your Own Collation Sequence

Changing a User-Defined Default

To change the default from your defined collation back to either Swedish, Norwegian, or one of the Japanese collations, execute the CollInstallMult macro as explained in the previous passages.

To return to the Teradata Standard Multinational collation, execute the CollAddStandard macro as explained in previous passages.

Note: Execution of the CallAddStandard macro will delete your defined codes before reloading the codes for the Teradata Standard Multinational collation.

Teradata RDBMS for UNIX SQL Reference G-39
International and Japanese Character Support

Japanese Character Support

Japanese Character Support

The Teradata RDBMS supports object names and data that contain 1OtrOduCtiOn Kanji, Katakana, Hiragana, and various other characters. This

allows you to name a Teradata RDBMS object and to insert and retrieve character and graphic data in Japanese. Here object name refers to table name, database name, user name, column, view, or macro name.

None of the additional characters can be used in SQL keywords.

Retrieving Multibyte Character Data Under a Different Character Set

Because the Teradata RDBMS uses:

Canonical representations for SQL terminal symbols (simple Latin letters, digits, etc.)

Non-canonical representations for multibyte characters.

multibyte character objects created under one character set, may not be accessible when retrieved under a different character set.

This issue can be alleviated if you observe the following rule:

For object names (not data), use simple Latin letters, digits (0-9), and the dollar sign ($), number sign (#), and underscore (_) for the names of all Teradata RDBMS users, passwords, accountids, databases, and database objects (tables, columns, views, macros, and checkpoints).

For stored data, use the CASESPECIFIC option to define all columns with a data type of CHAR, VARCHAR, or LONG VARCHAR.

You can query the DBC.CharSets and DBC.CharTranslations views to review the contents of the system tables associated with international character support. If the views are empty or do not exist, Kanji character sets are not available.

The predefined character sets allow the Teradata RDBMS to accept Using Kanji Characters Kanji ideographs from the following client environments:

IBM VM and MVS

UNIX

DOS/V Windows
Previous << 1 .. 219 220 221 222 223 224 < 225 > 226 227 228 229 230 231 .. 241 >> Next