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

SQL Anywhere 11.0.1 » SQL Anywhere Server - Database Administration » Configuring Your Database » International languages and character sets » International language and character set tasks


Determining the default collation

If you do not explicitly specify a collation when creating a database, a default collation is used. The default collation depends on the operating system you are working on.

To determine the default collation for your computer
  1. Start Interactive SQL.

  2. Connect to the sample database.

  3. Enter the following query:

    SELECT PROPERTY( 'DefaultCollation' );

    The default collation is returned.

    For more information about this collation, see Choosing collations.