Bookshelf v8.1/8.2: About Case-Insensitive and Accent-Insensitive Queries and Searches

By default, queries and searches in Siebel Business 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 Siebel database. For information about how to implement CIAI queries and searches on particular columns or fields, see Configuring Siebel Business Applications. For information about how the CIAI feature affects performance, see Siebel Performance Tuning Guide.

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, <Case Required> text appears in the field.

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

Table 9. Database Support for CIAI Queries
Database	Case Insensitive	Accent Insensitive
DB2	Yes	No
MSSQL	Yes	Yes
Oracle	Yes	No

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

NOTE: Search strings against the DB2 database must not be longer than the size of the column being searched.

Forcing Case-Sensitive or CIAI Queries or Searches

Regardless of the setting for case-sensitive and accent-sensitive queries, users can use operators to force case-sensitive or CIAI queries or searches. Table 10 describes the operators to use to force case-sensitive or CIAI queries or searches.

Table 10. Operators to Force Case-Sensitive or CIAI Queries or Searches
Type of Query	Operator	Examples
Case sensitive and accent sensitive	= followed by the criterion in single quotation marks	='Computer' returns only records that have Computer spelled with a capital C.

In searches with complex criteria, the user must also use the tilde (~) operator to force the CIAI feature, regardless of the setting for case-sensitive and accent-sensitive queries and searches.

Siebel Applications Administration Guide		Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices.