Collations

A collation describes how to sort and compare characters from a particular character set or encoding. SAP Sybase IQ supports two collation algorithms: the SAP Sybase IQ Collation Algorithm (SACA), and the Unicode Collation Algorithm (UCA). SACA provides fast, compact, and reasonable sorting at the expense of linguistic correctness. UCA provides linguistic correctness, but with a small expense in storage requirements and execution time.

• SAP Sybase IQ Collation Algorithm (SACA)
  The SAP Sybase IQ Collation Algorithm (SACA) provides reasonable comparison, ordering, and case conversion of single-byte and multibyte character sets. The algorithm is space efficient and fast. The mapped form of a string, such as an index, is the same length as the original string. The mappings for comparison, ordering, and case conversion use a simple table lookup of each byte value of the string.
• Unicode Collation Algorithm (UCA)
  The Unicode Collation Algorithm (UCA) is an algorithm for sorting the entire Unicode character set. It provides linguistically correct comparison, ordering, and case conversion. The UCA was developed as part of the Unicode standard. SAP Sybase IQ implements the UCA using the International Components for Unicode (ICU) open source library, developed and maintained by IBM.
• Collations in an SAP Sybase IQ database
  
• Alternate collations
  The following table lists compatibility collations that can be used with the SORTKEY and COMPARE functions.
• Turkish character sets and collations
  The Turkish language has two forms of what appears to be the letter I. One form, referred to as I-dot, appears as the following: