Bookshelf Home | Contents | Index | PDF |
Siebel Fundamentals > Using Query to Locate Information > About Querying > Case and Accent Insensitive QueriesSiebel 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 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. | |