Enabling Application-Wide Case Insensitivity

About the CaseInsensitive Parameter

Application-wide case sensitivity is controlled through the CaseInsensitive parameter of the named subsystem representing the data source definition.

The CaseInsensitive parameter only affects which data is retrieved by queries. It does not affect the order in which data appears on the screen. The sort sequence is database-dependent, and independent of the CaseInsensitive parameter.

In addition, the content of SRF files is case-sensitive in most cases and is not affected by how this parameter is set in the application configuration file.

You change the CaseInsensitive parameter in different ways, depending on whether you are working with Siebel Web Client or Siebel Developer Web Client:

About the InsensitivityFactor Parameter

When you change the CaseInsensitive parameter, you may also want to change the InsensitivityFactor parameter to minimize performance degradation.

The default setting for the InsensitivityFactor parameter is 2.

NOTE: Do not change the default value of InsensitivityFactor for Gateway Data Source (GatewayDataSrc) in the CFG file.

You may want to test a number of values for this parameter with your database, spool the SQL to see the effect of different settings on response time and then choose a value that meets your needs. For more information about the InsensitivityFactor parameter, see Siebel System Administration Guide.

Enabling Application-Wide Case Insensitivity for Siebel Web Client

For Siebel Web Client, you make changes to the CaseInsensitive parameter in the Administration - Server Configuration screen.