HomePowerBuilderAppeon Documentation Center

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

O90 Oracle9i

O10 Oracle 10g

ORA Oracle (for 11g and later)

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.


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:

    SQLCA.DBParm="MixedCase=1"
Prev  Up  Next
MaxFetchBuffer  Home  Mode