Data Mismatch for Binary Datatype

Question

Why is the SQL Server connector skipping 0x from the column values while replicating the data to the destination?

Environment

Connector: SQL Server

Answer

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.

Cause

SQL Server uses 0x as an indication that the value is binary.