ASA SQL Reference
System Tables
| Column name | Column type | Column constraint | Table Constraints |
|---|---|---|---|
| collation_label | CHAR(10) | NOT NULL | Primary key |
| collation_name | CHAR(128) | NOT NULL | |
| cs_label | CHAR(128) | ||
| so_case_label | CHAR(128) | ||
| so_caseless_label | CHAR(128) | ||
| jdk_label | CHAR(128) |
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 collation name used to describe the character set encoding.
cs_label The GPG character set mapping label.
so_case_label The collation sort order for case-sensitive GPG character set mapping.
so_caseless_label The collation sort order for case-insensitive GPG character set mapping.
jdk_label The JDK character set label.
For newly-created databases, this table contains only one row with the database collation mapping. For databases created with version 7.x or earlier of Adaptive Server Anywhere, this table includes collation mappings for all built-in collations.