BlobSize parameter

[Michael]

Is it somehow possible to use -1 as BlobSize parameter for reading an unlimited blob length, or will it be possible in a future driver release?

Or is it a Sybase restriction that the driver can't know the size before getting the data?

TIA
-Michael

[VISOCO]

Hi!

-1 means default value (32k). Unlimited blob length cannot be defined.
Sybase always need this limit.

VISOCO Software Support
support@visoco.com

[Michael]

Thanks for the answer (and sorry for the delay). I'm almost ready with the tests, going to buy next week. Wish you a happy new year!

[bmarinel]

Hi,

I have a large TMemoryStream (over 1MB) that I'm trying to put into a Sybase text field.

Here is my code:

MySQLQuery.ParamByName('MyTextField').LoadFromStream(MyMemoryStream, ftMemo);

It works fine, but only seems to write the first 32KB.

In my connection parameters I specify:

BlobSize=64000000

Does anyone know why this isn't working?

Regards,

Bill

[Mat000]

Hi,

There is no restriction on the size of the BLOb data you are putting to the table (except the restriction of the BLOb field itself, of course).

So, BlobSize parameter doesn't affect insert and update operations. Could you check if the necessary data were inserted into the table ?

Maybe, all data were inserted, but you are still retrieving first 32K. BlobSize parameter specifies the number of kilobytes. Try to set BlobSize=65536. This will be enough for 64 megabytes of BLOb data.

[bmarinel]

Thank you. That worked.