The database collation sequence includes alphabetic ordering of letters, which extends to all characters in the character set, including digits and space characters.
More than one character can be associated with each sort position. This is useful, for example, to treat an accented character the same as the character without an accent.
Two characters with the same sort position are considered by the database to be identical in all ways. Therefore, if a collation assigned the characters 'a' and 'e' to the same sort position, then this query:
WHERE col1 = 'want'
is satisfied by a row for which col1 contains the entry went.
At each sort position, lowercase and uppercase forms of a character can be indicated. For case-sensitive databases (the default for SAP Sybase IQ databases), lowercase and uppercase characters are not treated as equivalent. For case-insensitive databases, lowercase and uppercase versions of the same character are considered equivalent.