ASA SQL Reference
System Tables
| 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.