MixedCase database parameter

Description

Specifies whether you want connections to an Oracle database
to be case sensitive or case insensitive.

By default, MixedCase is set to 0. This setting specifies
a case-insensitive connection and assumes that all identifiers are
uppercase. To make the Oracle connection case sensitive, set the
MixedCase parameter to 1.

Controls

• O90 Oracle9i

• O10 Oracle 10g

• ORA Oracle 11g

Syntax

Parameter	Description
value	Specifies whether an Oracle database connection is case sensitive or case insensitive. Values are: 0 (Default) The Oracle database connection is case insensitive. It assumes that all identifiers are uppercase. 1 The Oracle database connection is case sensitive. It supports mixed case, uppercase, and lowercase identifiers.

Default

MixedCase=0

Usage

When you set the MixedCase parameter to 1 and define a primary
key for a table in an Oracle database, all of the following must
contain only uppercase letters:

• The
  name of the primary key

• The name of the table containing the primary key

• The names of any foreign keys that reference the
  primary key

Examples

---