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 */ );