Chapter 15 System Tables
1001
SYSCOLLATION system table
Column name Column type
Column
constraint
Table
constraint
collation_id SMALLINT NOT NULL Primary key
collation_label CHAR(10) NOT NULL
collation_name CHAR(128) NOT NULL
collation_order BINARY(1280) NOT NULL
This table contains the collation sequences available to Adaptive Server
Anywhere. There is no way to modify the contents of this table.
collation_id A unique number identifying the collation sequence. The
collation sequence with collation_id 2 is the sequence used in previous
versions of Adaptive Server Anywhere, and is the default when a database is
created.
collation_label A string identifying the collation sequence. The collation
sequence to be used is selected when the database is created, by specifying
the collation label with the
-z option.
collation_name The name of the collation sequence.
collation_order An array of bytes defining how each of the 256 character
codes are treated for comparison purposes. All string comparisons translate
each character according to the collation order table before comparing the
characters. For the different ASCII code pages, the only difference is how
accented characters are sorted. In general, an accented character is sorted as
if it were the same as the nonaccented character.
To Next Page
Loading...