Toad World® Forums

strange result in table Single Object Compare


#1

My initial compare between 2 tables showed differences on all the tables’ VARCHAR2 columns, e.g. VARCHAR2(10) vs. VARCHAR2(10 BYTE) -.

I did a compare of another set of tables - no differences.

Went back to my original 2 tables, Spooling the SQL to Screen (I was curious what was causing the diffs) - no differences.

To reproduce, I disconnect from target db, rt-click source table -> Compare with another object, target object - connect to target db, choose correct schema, Compare - shows the BYTE differences.

Compare a 2nd time - no differences.


#2

What versions are the two DBs?


#3

Nevermind, I found the problem. It’s fixed for next beta.