Example of Installing a Japanese Character Standard Collation - Advanced SQL Engine - Teradata Database

International Character Set Support

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-28
dita:mapPath
xnf1627504141606.ditamap
dita:ditavalPath
xnf1627504141606.ditaval
dita:id
B035-1125
lifecycle
previous
Product Category
Teradata Vantage™

The following script is an example of uninstalling and installing a standard Japanese character collation:

   DELETE FROM DBC.CollationsV
     WHERE CollName = 'KANJI5026_STANDARD';
   INSERT INTO DBC.CollationsV
    ( CollName
    , CollInstall
    , CollEqvClass
    , CollOrderCS
    , CollOrderUC )
    VALUES
    ( 'KANJI5026_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__ */
    ||'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             */
    , '00010203372d2e2f1605250b0c0d0e0f'xb  /* 00__ */
    ||'b14a5fb2a03d322618193f271c1d1e1f'xb  /* 01__ */
    ||'405a7f7be06c507d4d5d5c4e6b604b61'xb  /* 02__ */
    ||'f0f1f2f3f4f5f6f7f8f97a5e4c7e6e6f'xb  /* 03__ */
    ||'7cc1c2c3c4c5c6c7c8c9d1d2d3d4d5d6'xb  /* 04__ */
    ||'d7d8d9e2e3e4e5e6e7e8e9705b80b06d'xb  /* 05__ */
    ||'79626364656667686971727374757677'xb  /* 06__ */
    ||'788b9babb3b4b5b6b7b8b9c04fd0a107'xb  /* 07__ */
    ||'102122232415061728292a2b2c090a1b'xb  /* 08__ */
    ||'30311a333435360838393a3b04143eff'xb  /* 09__ */
    ||'11414243444546474849515253545556'xb  /* 0a__ */
    ||'588182838485868788898a8c8d8e8f90'xb  /* 0b__ */
    ||'9192939495969798999a9d9e9fa2a3a4'xb  /* 0c__ */
    ||'a5a6a7a8a9aaacadaeafbabbbcbdbebf'xb  /* 0d__ */
    ||'2057596a9ccacbcccdcecfdadbdcddde'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             */
    , '00010203372d2e2f1605250b0c0d0e0f'xb  /* 00__ */
    ||'b14a5fb2a03d322618193f271c1d1e1f'xb  /* 01__ */
    ||'405a7f7be06c507d4d5d5c4e6b604b61'xb  /* 02__ */
    ||'f0f1f2f3f4f5f6f7f8f97a5e4c7e6e6f'xb  /* 03__ */
    ||'7cc1c2c3c4c5c6c7c8c9d1d2d3d4d5d6'xb  /* 04__ */
    ||'d7d8d9e2e3e4e5e6e7e8e9705b80b06d'xb  /* 05__ */
    ||'79c1c2c3c4c5c6c7c8c9d1d2d3d4d5d6'xb  /* 06__ */
    ||'d7d8d9e2e3e4e5e6e7e8e9c04fd0a107'xb  /* 07__ */
    ||'102122232415061728292a2b2c090a1b'xb  /* 08__ */
    ||'30311a333435360838393a3b04143eff'xb  /* 09__ */
    ||'11414243444546474849515253545556'xb  /* 0a__ */
    ||'588182838485868788898a8c8d8e8f90'xb  /* 0b__ */
    ||'9192939495969798999a9d9e9fa2a3a4'xb  /* 0c__ */
    ||'a5a6a7a8a9aaacadaeafbabbbcbdbebf'xb  /* 0d__ */
    ||'2057596a9ccacbcccdcecfdadbdcddde'xb  /* 0e__ */
    ||'dfe1eaebecedeeeffafbfcfd3c1213fe'xb  /* 0f__ */
    /*  0 1 2 3 4 5 6 7 8 9 A B C D E F             */
    );