ASCII and EBCDIC Collations - Teradata Database

The ASCII collation sequence and the EBCDIC collation sequence are always available.

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.

If the COLLATION parameter is not defined, the default is HOST (the collation that is compatible with the logon client).

HOST collation gives you ASCII collation on network-attached clients and EBCDIC collation on mainframe clients.

For details on Teradata Database collating conventions, see:

“Comparison Operators” and “Comparisons for KANJI1 Characters” in SQL Functions, Operators, Expressions, and Predicates

“ORDER BY Clause” in SQL Data Manipulation Language