Devart Forums

Our assumptions were not confirmed. The problem does not arise when generating a unique index. The metadata on your server is correct, as shown by the results of scripts executed on your server. Comparison options do not affect the comparison result, this was shown by the * .dcom file you sent, which differs from "our" options in IgnoreSerialColumns and IsIgnoreTime. Because There are no serial and datetime columns in the source and target tables, these differences in options do not affect anything.

Probably the problem is that you have collate cp273.UTF-8 set for your database, which affects the result of ORDER BY in the SPT-2609 Select source table.sql and SPT-2609 Select target table.sql scripts that are used by Data Compare in the comparison process data. It is known that on the databases on which we tried to reproduce the collate en_US.utf8 problem.

To verify that the problem is in collate cp273.UTF-8, we want to ask to execute two scripts SPT-2609 Select source table.sql and SPT-2609 Select target table.sql and send the results of their execution.

Scripts are available via https://drive.google.com/drive/folders/ ... sp=sharing

SPT-2609 Select source table.sql
"f235_cg";"f235_ci";"f235_ch";"svs_schluesselart";"svs_mandant";"svs_gueltig_von";"svs_gueltig_bis";"svs_text";"svs_sprache"
"ZQZ-KARL-ART-STRG ";"0020";"1 ";"C";"01";"19000101";"29991231";"Txt-Sarlehen ";"D"
"ZQZ-KARL-ART-STRG ";"0020";"2 ";"C";"01";"19000101";"29991231";"Bakward-Sarlehen ";"D"

SPT-2609 Select target table.sql
"f235_cg";"f235_ci";"f235_ch";"svs_schluesselart";"svs_mandant";"svs_gueltig_von";"svs_gueltig_bis";"svs_text";"svs_sprache"
"ZQZ-KARL-ART-STRG ";"0020";"L ";"C";"01";"20200304";"29991231";"Texte Freiheit ";"D"
"ZQZ-KARL-ART-STRG ";"0020";"1 ";"C";"01";"19000101";"29991231";"Txt-Sarlehen ";"D"
"ZQZ-KARL-ART-STRG ";"0020";"2 ";"C";"01";"19000101";"29991231";"Bakward-Sarlehen ";"D"

Thank you. We will investigate it.

We have localized the problem, it is associated with the use of a specific collation: cp273.UTF-8. Using more standard collation options does not reproduce the problem. We will investigate this behavior and fix it in one of the next releases,