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

JIS_COLL collation orders data as follows:

  1. Characters and symbols from the JIS X 0201 standard (in JIS X 0201 order).
  2. Ideographs, characters and symbols from the JIS X 0208 standard (in JIS X 0208 order).
  3. Ideographs, characters and symbols from the JIS X 0212 standard (in JIS X 0212 order).
  4. IBM Kanji ideographs not present in JIS X 0201, JIS X 0208, and JIS X 0212 (in KanjiEBCDIC order).
  5. Site-defined ideographs (in Unicode order).
  6. The remaining characters in Unicode (in Unicode order).

Collation of the KANJISJIS, GRAPHIC, and LATIN character sets is as if the data were first converted to Unicode and then the appropriate JIS_COLL ordering were applied.