Hello,

I am trying to write/read big binary files to/from ADS using ODBC. Until now, the only way I found is to convert all as a string in hexa and store it into a Memo field type. But this way doubled the size of the data and also requests conversion for both read&write. Can anybody tell me a better way to do this?

I saw that ADS has a Binary field type. How can be used from ODBC?

I am using ADS 10.

Thanks,

Titus

asked 03 Mar '16, 15:10

Titus's gravatar image

Titus
466611
accept rate: 0%

edited 03 Mar '16, 15:10


ADS 10 is quite old. With ADS 11 you could use CHAR2HEX and HEX2CHAR to convert binary content into a string field and vice versa.

link

answered 06 Mar '16, 18:26

Joachim%20Duerr's gravatar image

Joachim Duerr
8.7k1031133
accept rate: 18%

And using ODBC how can I pass to ADS the binary data to be able to use CHAR2HEX?

If I can do this, I can store all inside a Binary field without any conversion.

(06 Mar '16, 18:37) Titus
Your answer to the original question.
If responding to a request for additional information, please edit the question or use the comment functionality.
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "Title")
  • image?![alt text](/path/img.jpg "Title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×8

Asked: 03 Mar '16, 15:10

Seen: 1,007 times

Last updated: 06 Mar '16, 18:37

Advantage Developer Zone Contact Us Privacy Policy Copyright Info


Powered by Advantage Database Server and OSQA
Disclaimer: Opinions expressed here are those of the poster and do not necessarily reflect the views of the company.