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.
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.
List the recommended collation sequences by typing the following at a command prompt:
The first column of the list is the collation label, which you supply when creating the database.
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
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'