Changing a database to another collation requires a rebuild of the database. Collations are chosen at database creation time and cannot be changed. For information on changing the collation by rebuilding the database, see “Changing a database from one collation to another” in SQL Anywhere Server – Database Administration > Configuring Your Database >International languages and character sets >International language and character set tasks.
