SQL Anywhere® Server - Database Administration  > 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 (Sybase Central)

• You can use the Create Database wizard in Sybase Central to create a database. The wizard has 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 by typing the following at a command prompt:

   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

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'

See also

• Tutorial: Creating a SQL Anywhere Database
• Creating a database
• CREATE DATABASE statement
• Initialization utility (dbinit)

---