Collation Sequence Ordering - 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ā„¢

Collation sequence ordering is as follows:

  • ASCII collation orders the data essentially as would converting the data to Teradata extended ASCII (the LATIN server character set), and then using a binary ordering of the resulting byte string.
  • EBCDIC collation orders the data essentially as would converting the data to Teradata extended EBCDIC, and then using a binary ordering of the resulting bytes.
  • CHARSET_COLL collation orders the data essentially as would converting the string to the current client character set, and then using a binary ordering of the resulting byte string.
  • JIS_Coll collation collates in the order of the Japanese Industrial Standards.
  • MULTINATIONAL collation provides more culturally aware ordering of data.

    The predefined multinational collation options are:

    • Teradata Standard Multinational (the initial default)
    • Swedish
    • Norwegian
    • Katakana_Standard
    • Kanji5026_Standard
    • Kanji5035_Standard

      Further multinational collation options can be loaded using scripts. The database administrator can alter MULTINATIONAL collation.

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

      You can execute predefined macros to change the default to Swedish, Norwegian, or the appropriate Japanese standard collation. You can also define and install your own collation, as explained in Defining Your Own Collation Sequence.

If all the items being compared or collated are determined to be NOT CASESPECIFIC, the collation works as if all characters that have an uppercase counterpart were converted to uppercase before being processed through ASCII, EBCDIC, CHARSET_COLL or JIS_COLL collation.