ASA SQL User's Guide
Transact-SQL Compatibility
Configuring databases for Transact-SQL compatibility
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 to other identifiers.
You decide the case sensitivity of Adaptive Server Anywhere data in comparisons when you create the database. By default, Adaptive Server Anywhere databases are case-insensitive 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. Case sensitivity can be changed for single-byte character sets by reconfiguring the Adaptive Server Enterprise sort order.
Adaptive Server Anywhere does not support case sensitive identifiers. In Adaptive Server Enterprise, the case sensitivity of identifiers follows the case sensitivity of the data. User IDs are treated like any other identified, and are always case insensitive. The default user ID for databases is upper case DBA.
In Adaptive Server Enterprise, domain names are case sensitive. In Adaptive Server Anywhere, they are case insensitive, with the exception of Java data types.
In Adaptive Server Anywhere, passwords follow the case sensitivity of the data. Extended characters used in passwords are case sensitive, regardless of the database's case sensitivity. The default password for databases is upper case SQL.
In Adaptive Server Enterprise, the case sensitivity of user IDs and passwords follows the case sensitivity of the server.