Data String Alignment Issue

rsiem

Using SQL Data Compare  Version 14.7.8.21163 Professional. Comparing same table and table structure data between 2 databases (production and test). Except for some of fields with string data the tables are identical. But Data Compare shows one table's field (Only in Left) as left justified (string data nvarchar) and the same field in the test database as right justified (string data nvarchar) - Only in Right. See attached screen shots. First screen shot show Only Left with data in right aligned columns while 2nd screen shot shows Only Right with data in left aligned columns.

How can I get Data Compare to compare the same aligned columns instead of showing incorrect differences?

 

rsiem

Have tried multiple compares and turning both on and off the Trim trailing white space, Force binary collation, and Treat empty string as NULL project options and defaults with same compare results.