Data Compare Error With PK Fields Containing Space Characters

[Russ Anderson]

DB Solo mistakenly gives me an error ("Found duplicate primary key
values in the destination table...") when a PK field value contains a
leading space character. Sample for illustration purposes:

Record1:
PK Field1 value: "One"
PK Field2 value: "-"

Record2:
PK Field1 value: "One"
PK Field2 value: " -" (note leading space)

DB Solo thinks these two records are identical, even though they are
not. (The second record Field2 value contains a leading space.)

The database is Oracle.

[DB Solo]

Make sure the 'Trim leading/trailing whitespace' option is not checked
on the Settings page. These settings also apply to the primary key
columns which could lead to the problem you described.