Preparing to Install or Upgrade › Considerations and Requirements Before Installation › Requirements and Considerations for the DBMS and CA MDB › Case Sensitivity

Case Sensitivity

CA Service Catalog and CA Service Accounting inherit CA MDB case-sensitivity characteristics. If SQL Server is the DBMS for CA MDB, then searches in CA Service Catalog and CA Service Accounting are case insensitive by default. Therefore, by default, you see case-sensitive search results for a field only if the field is defined explicitly as case sensitive.

Similarly, if Oracle is the DBMS for CA MDB, then searches in CA Service Catalog and CA Service Accounting use the Oracle DBMS characteristics. In that case, you expect case-sensitive searches.

For example, suppose you search for an account by clicking Home, Search, Account. With SQL Server, you expect case-insensitive search results. In contrast, with Oracle, you expect case-sensitive search results.