Database / Compare / Data may fail if NLS_SORT differs

Toad for Oracle - Beta
1

I have just compared the data of a table in two different schemas (different servers).

Since NLS_SORT has a different default value on the two servers, the sorting is different.
In my case, NLS_SORT is set to GERMAN on one server, while it is set to BINARY on the other.

As a result, identical data records are listed as “Target Only” and “Source Only”.

TOAD ORACLE 25.3 - COMPARE DATA is not working properly
3

Hi Dirk -

Looks like this was fixed and then broke. We should be specifying NLSSORT in the ORDER BY clauses but we are not.

It will be fixed in the next beta.

-John