Understanding Collations

A collation describes how to sort and compare characters from a particular character set or encoding.

For information about the supplied collations, see SQL Anywhere Server – Database Administration > Configuring your database > International languages and character sets > Understanding collations.

For suggestions as to which collations to use under certain circumstances, see SQL Anywhere Server – Database Administration > Configuring your database > International languages and character sets > Character set and collation reference information.

For a list of character sets, code pages, encodings and collations recommended for use with Windows and Unix platforms, see SQL Anywhere Server – Database Administration > Configuring your database >International languages and character sets > Character set and collation reference information > Recommended character sets and collations.

• Displaying Collations
  Obtain the currently used collation.
• ANSI and OEM Code Pages
  Sybase IQ collations are based on code pages that are designated as either ANSI or OEM.
• ANSI ISO_1 Collation
  ISO_1 is provided for compatibility with the Adaptive Server Enterprise default ISO_1 collation.
• ANSI 1252LATIN1 Collation
  This collation includes the euro currency symbol and several other characters (Z-with-caron and z-with-caron).
• ANSI ISO1LATIN1 Collation
  This collation is the same as ISO_1, but with sorting for values in the range A0-BF.
• ANSI ISO9LATIN1 Collation
  This collation is the same as ISO1LATIN1, but includes the euro currency symbol and the other new characters included in the 1252 LATIN1 collation.
• Multibyte Collations
  Sybase IQ provides collations using several multibyte character sets.