Case Sensitivity and Identifiers

Sensitivity to the case (upper or lower) of identifiers and data depends on the sort order installed on your SAP ASE server.

Case sensitivity can be changed for single-byte character sets by reconfiguring SAP ASE’s sort order; see the System Administration Guide for more information. Case is significant in utility program options.

If the SAP ASE server is installed with a case-insensitive sort order, you cannot create a table named MYTABLE if a table named MyTable or mytable already exists. Similarly, the following command returns rows from MYTABLE, MyTable, or mytable, or any combination of uppercase and lowercase letters in the name:

select * from MYTABLE