My Oracle Support Banner

Case Insensitive Search (Doc ID 509137.1)

Last updated on JULY 12, 2021

Applies to:

Siebel System Software - Version SIA [16061] 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):

    [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?




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.