Siebel Applications Administration Guide > Ongoing Application Administration Tasks >

About Case-Insensitive and Accent-Insensitive Queries and Searches

By default, queries and searches in Siebel applications are sensitive to case and accent. If you perform a query or search, there is a match only if the search criteria you enter are capitalized and accented in the same way that the data is capitalized and accented in the database.

If you do not want queries and searches to be case sensitive and accent sensitive, you can enable case-insensitive and accent-insensitive (CIAI) queries and searches on particular columns and fields in Siebel Tools. If you enable CIAI queries on a column, when you enter the query in the Siebel application, the field for the CIAI column is empty. When you enter the queries for fields that are not CIAI-enabled, the text, <Case Required>, is displayed in the field.

Not all types of database support both case-insensitive and accent-insensitive queries and searches on CIAI-enabled columns. Table 11 lists which CIAI features are supported in each type of database.

For information about how to implement CIAI queries and searches on particular columns or fields, see Configuring Siebel Business Applications. For information on how the CIAI feature affects performance, see Siebel Performance Tuning Guide.

NOTE:  Determine your requirements for case-insensitive queries and searches, and set the appropriate parameters for fields before users enter any data.