Creating a database with a custom collation

If none of the supplied collations meet your needs, you can create a database using a custom collation. The custom collation is used in indexes and any string comparisons.

Create a custom collation.

You must have a custom collation in place to use when creating a database.

For instructions on how to create custom collations, see “Creating a custom collation”.
Create the new database.

Use the CREATE DATABASE statement or Sybase Central, specifying the name of your custom collation.

For example, the following statement creates a database named newcol.db using the custom collation sequence newcol.
```
CREATE DATABASE 'newcol.db'
COLLATION 'newcol'
IQ PATH 'newcol.iq'
```