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.
Applies to
O90 Oracle9i
O10 Oracle 10g
ORA Oracle 11g
Syntax
|
1 |
MixedCase=value |
|
Parameter |
Description |
|---|---|
|
value |
Specifies whether an Oracle database connection is
|
Default value
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
To make an Oracle database connection case sensitive:
-
Database profile
Select the Case Sensitive check box on the Connection page in
the Database Profile Setup dialog box. -
Application
Type the following in code:
1SQLCA.DBParm="MixedCase=1"