Case Insensitive Search
Last updated on JULY 25, 2017
Applies to:Siebel System Software - Version 220.127.116.11 SIA  and later
z*OBSOLETE: Microsoft Windows 2000
We have a requirement to perform case insensitive queries on some fields of the Siebel database like Last Name, First Name, Street Address, Postal Code and City. We don't want to use the Siebel "Case Insensitive" option (in the Siebel CFG) because it will have a major impact on the performance of our application and we just want to peform a case insensitive search on specific fields and not on all fields.
Our DBA has found that a new functionality was available in SQL Server 2000: it is possible to change the character set of a specific column in a table in order to set this field to case insensitive.
We have tested this functionality and it seems to work fine.
You can see the change that need to be done in the following SQL statement (see definition of last name and fst name):
CREATE TABLE [S_CONTACT] (
[MS_IDENT] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
[ROW_ID] [varchar] (15) COLLATE Latin1_General_BIN NOT NULL ,
[CREATED] [datetime] NOT NULL CONSTRAINT
[FST_NAME] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[LAST_NAME] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[PRIV_FLG] [char] (1) COLLATE Latin1_General_BIN NOT NULL CONSTRAINT
Do you know if this functionality would be supported by Siebel or if another Siebel customer is using this?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms