How can we help you today? How can we help you today?

Compare shows differences but they are not different

I am comparing two tables with columns that are defined as CHAR(1). I have the "Trim trailing spaces" checked and the "Forced binary collation" option is NOT checked.

Any ideas of why it says that a "N" in one table is not the same as "N" in another table?

Out of 314351 rows it show 49380 rows being different. Most of which are not different.
nesr235
0

Comments

3 comments

Sort by
  • Brian Donahue
    Hi Russ,

    I'm not sure what's going on there, but I would imagine that if you choose one of these rows using a SQL query, casting the column as VARBINARY will probably show different values. If it does, then the 'N's are probably different characters.
    Brian Donahue
    0
  • nesr235
    Thanks for your response. I checked again, and they were showing differences but I could not tell that there were any.

    I finally did a work around. I extracted the table to a flat file to my hard drive of the two different tables, then I did a compare using pgm called "EXAMDIFF". Redgate showed something like 49,000 + errors. After extracting the table to a txt file "EXAMDIFF" found 249 errors.

    Other tables I have not had any issues.
    nesr235
    0
  • Brian Donahue
    Hi Russell,

    Sorry, but we'd probably need a copy of the database to work this out. I'd bet that if you tried looking at the actual data in binary form, you would see some difference.
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.