Collate and Sort Order Information

The data comparer shows this window if you have strings as a part of the primary key and comparison or sort ordering settings are different. There are three modes for this window: "if necessary" (default), "always" or "never". The mode can be changed at "User Interface" page of the settings window.

The comparer expects coincidence of the following database sort order parameters:

  • Case sensitivity. It is recommended to use "case sensitive" mode.
  • 'a' is greater than 'B'. The recommended setting is TRUE.
  • 'a' is greater than '1'. The recommended setting is TRUE.
  • 'a' is greater than 'A'. The recommended setting is TRUE.

In case the program could not find the optimal pair of options the user can assign them manually. To do that please:

  1. Switch on "specify options manually" checkbox.
  2. Select or enter required collation or sort order mode for one or both databases.
  3. Click "test" to analyze changes.

Note: if the drop-down menu is empty just enter required option manually.
If it is disabled at all you should assign or change this option outside the data comparer. Currently, the program offers built-in option change feature for Oracle, DB2, MS SQL and MySQL only.

DTM Data Comparer: show collation and sort order options