Sybase 12.4.2 manual Compatibility issues, Creating a database with a custom collation, 351

CHAPTER 9 International Languages and Character Sets

Stop and restart the database server in order for it to recognize the new collations and insert them into system tables SYSCOLLATION and

SYSCOLLATIONMAPPINGS.

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.

❖To create a database with a custom collation:

1Create 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” on page 349.

2Create 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’

Compatibility issues

Prior to version 12.0, Adaptive Server IQ always used the ASCII sort order, which sorts uppercase characters before lowercase. As of version 12.4.2, by default IQ databases sort data in the same way as pre-version 12 Adaptive Server IQ. The default applies these CREATE DATABASE options:

CREATE DATABASE dbname

COLLATION ’ISO_BINENG’

BLANK PADDING ON

CASE RESPECT

351