Case Insensitivity Wizard Defaults

The only required inputs for the Case Insensitivity Wizard are Table Name and Column Name. If you omit the other fields, then the wizard uses the default settings.

Methods

The Case Insensitivity Wizard uses the following default settings for the methods:

• In the repository, if the Force Case property is set on the column, then the wizard uses the Force Case method.

• If the Force Case property is not set, then the wizard uses the Database method.

Index Strategy

The Case Insensitivity Wizard uses the following defaults for index strategy:

• If the method is Force Case, then the wizard sets the index strategy to None.

• If the method is Database, and the base column does not have indexes defined on it, then the wizard sets the index strategy to None.

• If the method is Database, and the base column has indexes defined on it, then the wizard uses the Copy All index strategy.

If the Case Insensitivity Wizard uses None as an index strategy, then the wizard does not define new columns or indexes. It sets Default Insensitivity to DB Case & Accent.

This setting means that the Case Insensitivity Wizard has the following default behaviors:

• When the Force Case property is set on a column, the wizard does not define columns or indexes.

• If the column has no indexes defined on it, then the wizard does not define columns or indexes.

Note that in both cases, the Case Insensitivity Wizard accepts the column as eligible but does not define columns or indexes. These default behaviors define the implicit eligibility requirements.

Operation

If you omit Operation, then the Case Insensitivity Wizard sets Operation to On, regardless of the method or index strategy.