Data Compare showing null values as zeroes for SQL Server bit columns (4225510)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Data Compare showing null values as zeroes for SQL Server bit columns
Description

When comparing a SQL Server 2005 table to an Oracle 10g table, columns in the SQL Server table defined as BIT datatype are showing zero as the value when the value is null, and kicking out as a difference compared to the corresponding null valued NUMBER columns in the Oracle table.
Resolution

WORKAROUND:
none

STATUS:
Waiting for fix in a future version of Toad for Data Analysts.
Defect ID

ST67125

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title