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 11.0.1 > 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 11.0.1 > SQL Anywhere Server – Database Administration > Configuring Your Database >International languages and character sets > Character set and collation reference information.

For compatibility collations that can be used with the SORTKEY and COMPARE functions, see SQL Anywhere 11.0.1 > SQL Anywhere Server – Database Administration > Configuring Your Database >International languages and character sets > Character set and collation reference information > Supported and alternate collations.

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