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.
O90 Oracle9i
O10 Oracle 10g
ORA Oracle 11g
MixedCase=value
MixedCase=0
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
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"
