The case-sensitivity of the data is reflected in indexes, in the results of queries, and so on.
You decide the case-sensitivity of SAP Sybase IQ data in comparisons when you create the database. By default, SAP Sybase IQ databases are case-sensitive in comparisons, although data is always held in the case in which you enter it.
Adaptive Server Enterprise 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.