sqlserver "image" to postgresql "bytea"

[richardbeare]

Describe the bug

I suspect this isn't a bug but a newbie problem. Appreciate any advice.

A source table in sqlserver with a blob column, reported as type image does not appear to be converted correctly to a destination column of type bytea in postgresql. It appears that string encoding is going on somewhere.

The resulting fields appear approximately twice the size of the original.

I've tested sink.disable.escape=true, with no change to results

To Reproduce
Steps to reproduce the behaviour:

1. Source table DDL

column name: blob_contents
type : image
length: 16

3. Sink table DDL

column name: blob_content
type: bytea

5. ReplicaDB configuration options-file.

######################## ReplicadB General Options ########################
mode=complete
jobs=1
############################# Soruce Options ##############################
source.connect=jdbc:sqlserver://sqlserverhostname:1433;databaseName=Workbench
source.user=
source.password=
source.table=tblblobs
source.connect.parameter.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
############################# Sink Options ################################
sink.connect=jdbc:postgresql://172.31.0.3:5432/testdb
sink.user=postgres
sink.password=??
sink.table=public.tblblobs
sink.connect.parameter.driver=org.postgresql.Driver
sink.disable.escape=true

Expected behavior

sink content should be the same as the source. Currently it is twice the size

Additional context
sqlserver is remote, replicadb and postgresql are running in separate docker containers on the same linux host.