Collation sequence ordering is as follows:
- ASCII collation is functionally equivalent to converting the data to Teradata extended ASCII (the LATIN server character set), and using a binary ordering on the resulting byte string.
- EBCDIC collation orders the data in the same way as converting the data to Teradata extended EBCDIC and then using a binary ordering of the resulting bytes.
- CHARSET_COLL collation orders the data in the same way as 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. VantageCloud Lake uses:
- Teradata Standard Multinational
- Swedish
- Norwegian
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.