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


DELETE FROM DBC.Collations WHERE CollName = 'KANJI5 02 6_STANDARD'; INSERT INTO DBC.Collations ( CollName , CollInstall , CollEqvClass , CollOrderCS , CollOrderUC )

VALUES

( 'KANJI5 02 6_STANDARD'

, 'N'

CollEqvClass. Equivalence class. */
0 1 2 3 4 5 6 7 8 9 A B C D E F */
00000000000000000000000000000000' 'xb /* 00__ */
00000000000000000000000000000000' 'xb /* 01__ */
00000000000000000000000000000000' 'xb /* 02__ */
00000000000000000000000000000000' 'xb /* 03__ */
00000000000000000000000000000000' 'xb /* 04__ */
00000000000000000000000000000000' xb /* 05__ */
00000000000000000000000000000000' xb /* 06__ */
00000000000000000000000000000000' xb /* 07__ */
00000000000000000000000000000000' xb /* 08__ */
00000000000000000000000000000000' xb /* 09__ */
00000000000000000000000000000000' xb /* 0a__ */
00000000000000000000000000000000' xb /* 0b__ */

G-32

Teradata RDBMS for UNIX SQL Reference
International and Japanese Character Support

Changing the Standard Multinational Default Collation

|| 00000000000000000000000000000000 xb /* 0c */
|| 00000000000000000000000000000000 xb /* 0d */
|| 00000000000000000000000000000000 xb /* 0e */
|| 00000000000000000000000000000000 xb /* 0f */
/* 0 1 2 3 4 5 6 7 8 9 A B C D E F */
/* CollOrderCS. Case-specific ordering */
/* 0 1 2 3 4 5 6 7 8 9 A B C D E F */
, 0 0 0102 03 3 72d2e2f16 052 5 0b0c0d0e0f xb /* 0 0 */
|| b14a5fb2a03d322 618193f2 71c1d1e1f xb /* 01 */
|| 4 05a7f7be06c5 07d4d5d5c4e6b6 04b61 xb /* 02 */
|| f0f1f2f3f4f5f6f7f8f97a5e4c7e6e6f xb /* 03 */
|| 7cc1c2c3c4c5c6c7c8c9d1d2d3d4d5d6 xb /* 04 */
|| d7d8d9e2e3e4e5e6e7e8e97 05b8 0b06d xb /* 05 */
|| 7962636465666768697172 73 74 757677 xb /* 06 */
|| 788b9babb3b4b5b6b7b8b9c04fd0a107 xb /* 07 */
|| 1021222 32415 06172 82 92a2b2c0 9 0a1b xb /* 08 */
|| 30311a333435360838393a3b04143eff xb /* 0 9 */
|| 11414243444 54 64 74 84 95152 53 54 5556 xb /* 0a */
|| 588182838485868788898a8c8d8e8f90 xb /* 0b */
|| 9192939495969798999a9d9e9fa2a3a4 xb /* 0c */
|| a5a6a7a8a9aaacadaeafbabbbcbdbebf xb /* 0d */
|| 2 0575 96a9ccacbcccdcecfdadbdcddde xb /* 0e */
|| dfe1eaebecedeeeffafbfcfd3c1213fe xb /* 0f */
/* 0 1 2 3 4 5 6 7 8 9 A B C D E F */
/* CollOrderUC. uppercase ordering /
/* 0 1 2 3 4 5 6 7 8 9 A B C D E F */
, 00010203372d2e2f160525 0b0c0d0e0f xb /* 0 0 */
|| b14a5fb2a03d322 618193f2 71c1d1e1f xb /* 01 */
|| 4 05a7f7be06c5 07d4d5d5c4e6b6 04b61 xb /* 02 */
|| f0f1f2f3f4f5f6f7f8f97a5e4c7e6e6f xb /* 03 */
|| 7cc1c2c3c4c5c6c7c8c9d1d2d3d4d5d6 xb /* 04 */
|| d7d8d9e2e3e4e5e6e7e8e97 05b8 0b06d xb /* 05 */
|| 7 9c1c2c3c4c5c6c7c8c9d1d2d3d4d5d6 xb /* 06 */
|| d7d8d9e2e3e4e5e6e7e8e9c04fd0a107 xb /* 07 */
|| 1021222 32415 06172 82 92a2b2c0 9 0a1b xb /* 08 */
|| 30311a333435360838393a3b04143eff xb /* 0 9 */
|| 11414243444 54 64 74 84 95152 53 54 5556 xb /* 0a */
|| 588182838485868788898a8c8d8e8f90 xb /* 0b */
|| 9192939495969798999a9d9e9fa2a3a4 xb /* 0c */
|| a5a6a7a8a9aaacadaeafbabbbcbdbebf xb /* 0d */
|| 2 0575 96a9ccacbcccdcecfdadbdcddde xb /* 0e */
|| dfe1eaebecedeeeffafbfcfd3c1213fe xb /* 0f */
/* 0 1 2 3 4 5 6 7 8 9 A B C D E F */

);

Teradata RDBMS for UNIX SQL Reference

G-33
International and Japanese Character Support

Defining Your Own Collation Sequence

Introduction

Definition of the CollInstallMulti Macro

Defining Your Own Collation Sequence

To create your own collation sequence, define for each character of the alphabet the hexadecimal representation for each of the following:

• The equivalence class

• The case-specific value

• The uppercase value

It is useful to have the hexadecimal representation for the Teradata internal value of the character, so that the above items can be placed in the appropriate position within the defining byte string, as shown in the preceding example.

Each group of values is inserted into a column in one row of DBC.Collations.

The rest of this section describes the CollInstallMulti macro, defines the columns of DBC.Collations, and explains how to populate the system table and install the collation.

The CollInstallMulti macro is used to take the codes you load into the DBC.Collations view and re-insert them into the underlying system table as the new default collation sequence.

The :CollationName parameter you submit to the macro must match the CollName value you specified for DBC.Collations.

The macro first verifies that the value of :CollationName is not ’MULTINATIONAL’ and then whether :CollationName is found in the CollName column of DBC.CollationTbl.

It next deletes the row where CollName is ’MULTINATIONAL’ and inserts through DBC.Collations a row with the following values:

• The string MULTINATIONAL in CollName

• The letter Y in CollInstall

• The codes for CollEqvClass, CollOrderCS, and CollOrderUC, which it selects from the row you loaded (where CollName should be equal to :CollationName).

The syntax of the CollInstallMulti definition is as follows:
Previous << 1 .. 217 218 219 220 221 222 < 223 > 224 225 226 227 228 229 .. 241 >> Next