You can obtain the currently used collation by typing the following command at the command prompt:
SELECT * FROM SYS.SYSCOLLATION
For information on supported, alternate, and recommended collations, see “Supported and alternate collations” and “Recommended character sets and collations” in SQL Anywhere Server – Database Administration > Configuring Your Database >International languages and character sets > Character set and collation reference information.
