Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » Database configuration » International languages and character sets » Collations


Collation considerations

You specify the collation for a database when you create the database. The default collation is inferred from the code page and language of the database server's computer's operating system. Usually the default collation is a suitable choice, but you can also explicitly specify a collation to match your needs from the wide selection of supplied collations. SQL Anywhere can support more than one collation for a particular language.

You should choose a collation that uses a character set and sort order that are appropriate for the data in your database. You can also specify collation tailoring options for additional control over the sorting and comparing of characters.

When choosing the collation for your database, consider the following:

  • There is a performance cost, and extra complexity in system configuration, when you use character set conversion. Choose a collation that avoids the need for character set conversion. Character set conversion is not used if the database server and client use the same character set.

    You can avoid character set conversion by using a collation sequence in the database that matches the character set in use on your client computer operating system. Choose the ANSI character set for Windows operating systems on the client computer.

  • If your client computers use a variety of characters sets, or if the database must store Unicode data, consider using the UCA and/or UTF8BIN collations. However, the UCA collation cannot be used with multibyte character sets other than UTF-8.

  • Choose a collation that uses a character set and sort order appropriate for the data in the database. It is often the case that there are several collations that meet this requirement.

 See also

Collation tailoring options