Binary Data String

More
3 years 1 month ago #11096 by campbell
After Updating to the latest release I found that my binary data strings are no longer correct.

Data strings that used to start like 0xFFD8FFE000104A46494... now appear as 0x5C3337375C3333305C3... and cannot be used by my applications. Also the length of the data strings appear to be twice the size they were before. Was there a code change for the formatting of binary data returns?

Thanks
JCampbell

Please Log in or Create an account to join the conversation.

More
3 years 1 month ago #11097 by campbell
The Binary data was converting to a UTF8 binary value. I did not have this as an option in my provider string to my linked server. In the newer version it might be set on as default?

Please Log in or Create an account to join the conversation.

More
1 year 3 months ago #13892 by campbell
We are once again not working with binary data. I believe I figured out why. the Postgresql server is outputting the values as escaped verses HEX. Is there a setting or parameters I can use on the driver to force binary values return as hex?

Escaped: 0x5C3337375C3333305C3
Hex: 0xFFD8FFE000104A46494

Please Log in or Create an account to join the conversation.

Time to create page: 0.612 seconds
Powered by Kunena Forum