Hello, I am trying to insert the document binary data from Appian to

Hello,

I am trying to insert the document binary data from Appian to MS SQL DB. I am using Query Database smart service.
And used the below statement:

CONVERT(varbinary(max),ac!Attachment)

ac!attachment is of type text which holds data as:
546573743132330D0A48656C6C6F0D0A48690D0A686F772061726520796F750D0A

whereas in DB It is storing the binary data as:
350034003600350037003300370034003300310033003200330033003000440030004100340038003600350036004300360043003600460030004400300041003400380036003900300044003000410036003800360046003700370032003000360031003700320036003500320030003700390036004600370035003000440030004100

Can you please let me know how we can make sure that the binary data remains same in MS SQL server.

Regards,
Vinit.

OriginalPostID-224460

OriginalPostID-224460