Contents Index Setting options for Transact-SQL compatibility Ensuring compatible object names

ASA SQL User's Guide
  Transact-SQL Compatibility
    Configuring databases for Transact-SQL compatibility

Case sensitivity


Case sensitivity in databases refers to:

Case sensitivity of data 

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.

Case sensitivity of identifiers 

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.

User IDs and passwords 

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.


Contents Index Setting options for Transact-SQL compatibility Ensuring compatible object names