MixedCase

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

O84 Oracle 8.x and Oracle8i
O90 Oracle9i
O10 Oracle 10g

Syntax

MixedCase = value

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.

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

Example 1

To make an Oracle database connection case sensitive:

Database profile Select the Case Sensitive check box on the Connection tab in the Database Profile Setup dialog box.
Application Type the following in code:
```
SQLCA.DbParameter="MixedCase=1"
```