Need for Case sensitive database

(Doc ID 522683.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Tools - Version 7.5.2 [15051] to [IP2013] [Release V7 to V8]
z*OBSOLETE: Microsoft Windows Server 2003
Product Release: V7 (Enterprise)
Version: [18372]
Database: Microsoft SQL Server 2005
Application Server OS: Microsoft Windows 2003 Server
Database Server OS: Microsoft Windows 2003 Server

This document was previously published as Siebel SR 38-3293944181.

***Checked for relevance on 01-Oct-2014***


Customer is currently running their development environment in a case-sensitive (CS) database and then move the build to other environments (test, stage, production), all of which have case-insensitive (CI) database. They are on MS SQL Server 2005 database.

Customer wanted to know the queries to the following questions

1. Does Siebel require or recommend doing development in a CS database?
2. If not, is there any performance gain when doing development in a CS database as compared to CI database?
3. Anything else that needs to be considered?


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