Sybase 12.4.2 User Manual

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.

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.

❖

1

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

2

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’

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