CREATE TABLE SYS.SYSCOLLATION ( collation_id SMALLINT NOT NULL, collation_label CHAR(10) NOT NULL, collation_name CHAR(128) NOT NULL, collation_order BINARY(1280) NOT NULL, PRIMARY KEY ( collation_id ) )
This table contains the collation sequences available to Sybase IQ. There is no way to modify the contents of this table.
collation_id A unique number identifying the collation sequence.
collation_label A string identifying each of the available collation sequences. The collation sequence to be used is selected when the database is created by specifying the collation label with the COLLATION option of the CREATE DATABASE command.
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 non-accented character.
