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 » How SQL Anywhere chooses the default collation for a new database

 

Determining the default collation

A collation describes how to sort and compare characters from a particular character set or encoding. If you do not explicitly specify a collation when creating a database a default collation is used, depending on the operating system.

Prerequisites

There are no prerequisites for this task.

 Task
  1. Connect to the database.

  2. Execute the following statement:

    SELECT PROPERTY( 'DefaultCollation' );

Results

The default collation for the database is returned.

 See also