Siebel Fundamentals for Siebel Open UI > Using Query to Locate Information > About Queries >

Case Insensitive and Accent Insensitive Queries

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 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 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. To find out if your Siebel application uses exact-match queries or CIAI queries, run test queries and review the query results. For more information about CIAI queries, see Siebel Global Deployment Guide.

Your Siebel administrator can configure specific 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. The fields that contain the Case Required property represent non CIAI-enabled fields.

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

NOTE:  For Siebel CRM product releases 8.1.1.9 and later and for 8.2.2.2 and later, the system requirements and supported platform certifications are available from the Certification tab on My Oracle Support. For information about the Certification application, see article 1492194.1 (Article ID) on My Oracle Support.