Edit on GitHub
Data Mismatch for Binary Datatypelink
Questionlink
Why is the SQL Server connector skipping 0x
from the column values while replicating the data to the destination?
Environmentlink
Connector: SQL Server
Answerlink
SQL Server uses 0x
only to represent binary values and the same is not a part of the original column value.
For example, if the SQL server shows the binary column value as 0x34556G9898
then, only 34556G9898
will be replicated to the destination.
For more information about binary data types, see Microsoft's documentation.
Causelink
SQL Server uses 0x
as an indication that the value is binary.