Sybase 12.4.2 Collation sequence section, Following are some sample lines for a collation, 341

CHAPTER 9 International Languages and Character Sets

The collation sequence section

Descriptions of arguments

After the title line, each non-comment line describes one position in the collation. The ordering of the lines determines the sort ordering used by the database, and determines the result of comparisons. Characters on lines appearing higher in the file (closer to the beginning) sort before characters that appear later.

The form of each line in the sequence is:

[sort-position] :character [ [, character ] ...]

or

[sort-position] :character [lowercase uppercase]

Argument	Description
sort-position	Optional. Specifies the position at which the characters on
	that line will sort. Smaller numbers represent a lesser value,
	so will sort closer to the beginning of the sorted set.
	Typically, the sort-position is omitted, and the characters sort
	immediately following the characters from the previous sort
	position.
character	The character whose sort-position is being specified.
lowercase	Optional. Specifies the lowercase equivalent of the character.
	If not specified, the character has no lowercase equivalent.
uppercase	Optional. Specifies the uppercase equivalent of the character.
	If not specified, the character has no uppercase equivalent.

Specifying character and sort-position

Multiple characters may appear on one line, separated by commas (,). In this case, these characters are sorted and compared as if they were the same character.

Each character and sort position is specified in one of the following ways:

Specification	Description
\dnnn	Decimal number, using digits 0-9 (such as \d001)
\xhh	Hexadecimal number, using digits 0-9 and letters a-f or A-
	F (such as \xB4)
’c’	Any character in place of c (such as ’,’)
c	Any character other than quote (’), backslash (\), colon (:)
	or comma (,). These characters must use one of the
	previous forms.

The following are some sample lines for a collation:

% Sort some special characters at the beginning:

341