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 8.1.1.11.11 [IP2013] [Release V7 to V8]
z*OBSOLETE: Microsoft Windows Server 2003
Product Release: V7 (Enterprise)
Version: 7.7.2.6 [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***

Goal

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?

Solution

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