Siebel 8 does away with the concept of turning query case sensitivity on and off with a simple switch. In order to allow for fine tuning and improved performance, case sensitivity is implied unless explicitly configured on a per Column object basis:
If you have case insensitive searching currently, you can configure this in Siebel 8 as follows:
- In your Tools folder, look in the OBJECTS folder where you’ll find some CSV files. These represent the recommended base column objects for which special Case Insensitive (CI) indexes should be created. You can add custom indexed table columns to this list.
- In Tools, connect to the server repository
- To make this easy, go to Projects and query for Name = *Table*. Use Edit > Change Records to lock these projects
- Select Tools > Utilities > Case Insensitivity…
- Click browse and locate the CSV file for either SEA or SIA applications. Click next.
- Tools will work out what it needs to do and will tell you if any projects or objects are not locked. You’ll need to cancel, lock the projects and re-run in this scenario
- Siebel will apply the changes required to your repository, creating new indexes for these columns and setting the Default Insensitivity property
To enable insensitivety for other, non-indexed columns:
- Select Tools > Utilities > Case Insensitivity…
- Click the ‘Enable for all unindexed columns…’ radio button. Click next.
- Tools will work out what it needs to do and will tell you if any projects or objects are not locked. You’ll need to cancel, lock the projects and re-run in this scenario
- Siebel will apply the changes required to your repository, setting the Default Insensitivity property
- Unlock all the projects, compile the SRF and run DDL sync
Easy as that! 
