Collation Sequence
A collation sequence determines in what order sorted data is returned to users and applications, what is returned when queries use pattern matching, and, in some instances, how data is stored internally.
Note: Specification of a collation sequence at the column level to support columns containing Unicode data is database dependent. The gateway does not enforce collation sequences for Unicode strings; consequently, Unicode strings may not adhere to Ingres collation sequence semantics.
Database-dependent restrictions that apply to collation sequences include:
• Ingres-Default is byte-for-byte string comparisons.
• DB2 UDB-Default is local alphabetic.