|
Case sensitivity in databases refers to:
Data The case sensitivity of the data is reflected in indexes and so on.
Identifiers Identifiers include table names, column names, and so on.
Passwords Passwords are always case sensitive in SQL Anywhere databases.
You decide the case-sensitivity of SQL Anywhere data in comparisons when you create the database. By default, SQL 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.
SQL Anywhere does not support case sensitive identifiers. In Adaptive Server Enterprise, the case sensitivity of identifiers follows the case sensitivity of the data. The default user ID for databases is DBA.
In Adaptive Server Enterprise, domain names are case sensitive. In SQL Anywhere, they are case insensitive, with the exception of Java data types.
In SQL Anywhere, passwords are always case sensitive. The default password for the DBA user ID is sql in lowercase letters.
In Adaptive Server Enterprise, the case sensitivity of user IDs and passwords follows the case sensitivity of the server.