ASA Database Administration Guide
  International Languages and Character Sets
    International language and character set tasks

Creating a database with a named collation

You may specify the collation for each database when you create the database. The default collation is inferred from the code page and sort order of the database server's computer's operating system.

To specify a database collation when creating a database (Sybase Central)

• You can use the Create Database wizard in Sybase Central to create a database. In the wizard, there is a page where you choose a collation from a list.

  

To specify a database collation when creating a database (command prompt)

1. List the recommended collation sequences:

   dbinit -l

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

   437LATIN1  Code Page 437, Latin 1, Western
   437ESP     Code Page 437, Spanish
   437SVE     Code Page 437, Swedish/Finnish
   819CYR     Code Page 819, Cyrillic
   819DAN     Code Page 819, Danish
   ...

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

To specify a database collation when creating a database (SQL)

• You can use the CREATE DATABASE statement to create a database. The following statement creates a database with a Greek collation:

  CREATE DATABASE 'mydb.db'
  COLLATION '1253ELL'