Comparison
This page's options make data compare process more flexible and
customizable.
| Setting |
Description |
Default |
| Field size to be compared |
The program compares only first N specified bytes of long
string and text objects |
8192 |
| Trim right spaces |
The program considers values like "1 " and "1" as equal if this
option is switched on |
No |
| Null values are not identical |
If this option is turned on the program consider any NULL as
unique value that not equals another NULL value |
No |
| Empty string equals NULL |
The program considers empty string equals NULL if this option
is switched on |
No |
| Show different rows only |
It allows you to see only different records during compare or
synchronization. This option can save a bit of memory for large
tables compare. |
No |
| Disable collation coordination |
The program disables collation and sort mode coordination
feature if this option is switched on |
Off |
| Numeric value comparison accuracy |
Defines difference for two numeric values that must be signed
as equal |
0.00001 |
|
