Sybase Adaptive Server IQ 12.4.2, Administration And Performance Manual

Page: 371 / 536

CHAPTER 9 International Languages and Character Sets
351
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:
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’
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