Case Insensitivity Wizard Modes

You can run the Case Insensitivity Wizard in one of two modes:

• Configure specified columns. You can specify the columns you want to configure for CIAI queries by using an input file or by selecting the files manually:

  • Use an input file. The Case Insensitivity Wizard reads the input file and configures the columns in the file for CIAI queries. Using an input file allows you to control which configuration options the wizard uses. Oracle provides recommended input files. These files contain columns frequently used in searches. Use an input file if you want to enable large numbers of columns or to use methods or index strategies other than the defaults.

  • Select columns manually. You can use the Tools Object Explorer to manually select and configure specific columns for CIAI queries. The Case Insensitivity Wizard uses default settings to configure these columns. If you want to modify the configuration options, then you can export the configuration strings to a text file, edit them, and run the wizard using the edited file as an input file.

  • Specify how queries are built for columns without indexes. The Case Insensitivity Wizard defines CIAI columns and indexes only on columns that already have indexes defined. However, for columns without indexes that meet all other eligibility criteria, you can run the Case Insensitivity Wizard in a special mode to change the Default Insensitivity property from None to DB Case & Accent. In queries, the column values are then converted to uppercase before being compared. This allows searches to be both case and accent insensitive.

    For example, in S_CONTACT, assume the column LAST_NAME has no indexes defined on it. You run the Case Insensitivity Wizard to set Default Insensitivity to DB Case & Accent. When you query for the name Smith, the Object Manager uses a query similar to the following (IBM DB2):

    SELECT column_list FROM S_CONTACT WHERE UPPER(LAST_NAME) LIKE UPPER(Smith)