1. DB Best Documentation
  2. Database Compare Suite
  3. Modifying comparison of string values
Database Compare Suite™

Modifying comparison of string values

When comparing string values, various problems can appear. For example, data values can be case-sensitive, and data fields can have leading or trailing spaces. In this case you have to manage the options for text data types correctly to avoid problems in data comparison.

  1. In the data options section, you can specify options for the text data types:
  2. Select Trimming mode from the drop-down list. Here are the options you can specify:

    • None – he application will compare all string values without modifications;
    • Leading – the application will trim the leading spaces in all string values before comparison;
    • Trailing – the application will trim the trailing spaces in all string values before comparison;
    • Both – the application will trim both leading and trailing spaces in all string values before comparison.
    • Here are the examples of using different values for the Trimming mode option. Let’s compare the values ”   Information   ” and “Information   “:
      Trimming mode Value 1 Value 2 Result
      None 
      "Information"
      		 
      "Information"
      		 Not equal
      Leading 
      "Information"
      		 
      "Information"
      		 Equal
      Trailing 
      "Information"
      		 
      "Information"
      		 Not equal
      Both 
      "Information"
      		 
      "Information"
      		 Equal
  3. Check the Ignore case option to ignore case matching during data comparison operation. If the checkbox is unchecked, the data comparison will be case-sensitive.Here are the examples of using different values for the Ignore case option. Let’s compare the values “Text” and “text”.
    Ignore case Result
    Unchecked Not equal
    Checked Equal
  4. Check the Treat empty as null option to use NULL instead of Empty value during data comparison operation. This option may be useful in case of comparing data after migration.
  5. Click the Reset button to restore default parameters for all modified options.
  6. Please note that the operation properties are stored by the application for the entire project, so all changes to the operation settings that you have made will be automatically used for all objects of the same type in your project.

Didn’t find the answer?

You can report problems, ask questions or share ideas for improvements on our email [email protected].