Collation internals

Collation files may include the following elements:

•Comment lines, which are ignored by the database.

•A title line.

•A collation sequence section.

•An Encodings section.

•A Properties section.

Comment lines

In the collation file, spaces are generally ignored. Comment lines start with either the percent sign (%) or two dashes (--).

The title line

The first non-comment line must be of the form:

Collation label (name)

In this statement:

Item

Description

Collation

A required keyword.

label

The collation label, which appears in the system tables as

 

SYS.SYSCOLLATION.collation_label and

 

SYS.SYSINFO.default_collation. The label must contain no

 

more than 10 characters, and must not be the same as one of the

 

built-in collations. (In particular, do not leave the collation label

 

unchanged.)

name

A descriptive term, used for documentation purposes. The name

 

should contain no more than 128 characters.

 

 

For example, the Shift-JIS collation file contains the following collation line, with label SJIS and name (Japanese Shift-JIS Encoding):

Collation SJIS (Japanese Shift-JIS Encoding)

340

Page 360
Image 360
Sybase 12.4.2 manual Comment lines, Title line, Collation internals, 340