Case Insensitive Search (Doc ID 509137.1)

Last updated on JULY 25, 2017

Applies to:

Siebel System Software - Version 7.5.2.211 SIA [16061] and later
z*OBSOLETE: Microsoft Windows 2000

Symptoms

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?

Changes

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms