Case Insensitive and Accent Insensitive Queries

When the case insensitive and accent insensitive (CIAI) query feature is implemented, database queries you perform in the Siebel application ignore both case and the use of accents to return records that otherwise match the query criteria. This capability is important when searching for records such as contact or customer names. For example, an exact-match query produces different a query results than a case insensitive and accent insensitive (CIAI) query if the query results contain capitalization inconsistencies (such as MacArthur and Macarthur) or accent usage inconsistencies. CIAI queries apply to the entire query string.

Tags