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

SQL Anywhere 11.0.1 (Français) » SQL Anywhere Server - Database Administration » Configuring Your Database » International languages and character sets » International language and character set tasks

 

Creating a database with a named collation

You can specify the collation for each 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.

For information about using the NCHAR collation, see NCHAR collation.

♦  To specify a database collation when creating a database (command prompt)
  1. Run the following command to list the recommended collation sequences:

    dbinit -l

    The first column of the list is the collation label, which you supply when creating the database.

  2. Create a database using the dbinit utility, specifying a collation sequence using the -z option. The following command creates a database with a Greek collation.

    dbinit -z 1253ELL mydb.db

    The following command creates a case sensitive database, spanish.db, which uses the 1262spa collation for non-NCHAR data. For NCHAR data, the UCA collation is specified, with locale es, and sorting by lowercase first.

    dbinit -c -z 1252spa -zn uca(locale=es;case=LowerFirst) spanish.db
♦  To specify a database collation when creating a database (SQL)
♦  To specify a database collation when creating a database (Sybase Central)
See also