Case sensitivity in databases refers to:
Data The case sensitivity of the data is reflected in indexes, in the results of queries, and so on.
Identifiers Identifiers include table names, column names, user IDs, and so on.
Passwords Case sensitivity of passwords is treated differently from other identifiers.
You decide the case-sensitivity of Sybase IQ data in comparisons when you create the database. By default, Sybase IQ databases are case-sensitive in comparisons, although data is always held in the case in which you enter it.
Adaptive Server Enterprise’s sensitivity to case depends on the sort order installed on the Adaptive Server Enterprise system. You can change case sensitivity for single-byte character sets by reconfiguring the Adaptive Server Enterprise sort order.
Sybase IQ does not support case-sensitive identifiers. In Adaptive Server Enterprise, the case sensitivity of identifiers follows the case sensitivity of the data.
In Adaptive Server Enterprise, user-defined data type names are case sensitive. In Sybase IQ, they are case insensitive.
In Sybase IQ, passwords follow the case sensitivity of the data by default; however, you can also specify password case sensitivity independently of data case sensitivity. The default password for case-sensitive databases is uppercase SQL. The default user ID is DBA, but it is not case sensitive.
In Adaptive Server Enterprise, the case sensitivity of user IDs and passwords follows the case sensitivity of the server.
