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

SQL Anywhere 12.0.0 (Français) » 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.