Siebel Fundamentals > Using Query to Locate Information > About Querying >

Case and Accent Insensitive Queries


Siebel query features provide indexes that directly support case insensitive and accent insensitive (CIAI) queries on eligible text columns. CIAI queries ignore both the case and use of accents to return all records that otherwise match your query. This capability is particularly important when searching for records such as contact or customer names. For example, a query that contains capitalization (such as MacArthur versus Macarthur) or where the use of accents is not consistent, an exact-match search might not return any records.

Your Siebel administrator can configure specified columns for CIAI queries by defining CIAI columns and CIAI indexes in the repository using the CIAI wizard in Siebel Tools. The CIAI wizard sets the Default Insensitivity property for CIAI columns to DB Case & Accent. CIAI-enabled fields are blank in the user interface. Whereas the fields that contain the property, Case Required, represent non CIAI-enabled fields.

A case-insensitive query works on all databases supported for the current release of the Siebel application. For more information about supported databases, see Siebel System Requirements and Supported Platforms on Siebel SupportWeb. However, accent-insensitivity works only on the databases that provide the accent-insensitivity functionality, such as Microsoft Structured Query Language (SQL).

Siebel Fundamentals Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Legal Notices.