Binary Data String
- campbell
- Topic Author
- Visitor
-
9 years 4 months ago #11096
by campbell
Binary Data String was created 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
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.
- campbell
- Topic Author
- Visitor
-
9 years 3 months ago #11097
by campbell
Replied by campbell on topic Re: Binary Data String
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.
- campbell
- Topic Author
- Visitor
-
7 years 6 months ago #13892
by campbell
Replied by campbell on topic Re: Binary Data String
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
Escaped: 0x5C3337375C3333305C3
Hex: 0xFFD8FFE000104A46494
Please Log in or Create an account to join the conversation.
Time to create page: 0.132 seconds