Applications Administration Guide > Ongoing Application Administration Tasks >

About Case Sensitivity

By default, Siebel applications are case-sensitive. If you perform a query or search, there is a match only if the search criteria you enter are capitalized in the same way the data is capitalized in the database.

If you do not want queries and searches to be case-sensitive, you can enable case insensitivity either for the entire application or for selected fields. Regardless of which setting you choose, users can use operators to force case-sensitive or case-insensitive searches.

For information on how case insensitivity affects performance, see Performance Tuning Guide.

To force a case-sensitive search, use the operator = followed by the criterion in single quotation marks. For example, if the user enters the criterion = 'Computer', the query returns only records that have "Computer" spelled with a capital C in the field.

To force a case-insensitive search, use the operator ~LIKE. For example, if the user enters the criterion ~LIKE computer, the query returns all records that have "computer" in the field, regardless of capitalization.

The user must also use ~LIKE to force case insensitivity in searches with complex criteria, regardless of the setting for case sensitivity.

NOTE:  You should determine your requirements for case-insensitive searching and set the appropriate parameters for the application or individual field before users enter any data.

Applications Administration Guide