International aspects of case sensitivity

SQL Anywhere is always case preserving and case insensitive for identifiers, such as system view names and column names. The names are stored in the case in which they are created, but any access to the identifiers is done in a case insensitive manner.

For example, the names of the system views are stored in uppercase (SYSDOMAIN, SYSTAB, and so on), but access is case insensitive, so that the two following statements are equivalent:

SELECT * FROM systab; SELECT * FROM SYSTAB;

The equivalence of upper and lowercase characters is defined in the collation. There are some collations where particular care is required when assuming case insensitivity of identifiers. For example, Turkish collations have a case-conversion behavior that can cause unexpected and subtle errors. The most common error is that a system object containing a letter I or i is not found.

For more information about Turkish character sets and collations, see Turkish character sets and collations.