Subject Re: [firebird-support] Maximum BLOB size and BLOB reuse ?
Author Ann W. Harrison
At 03:49 PM 6/15/2004, benedicte_asselin wrote:


>- what is the maximum content size of a BLOB

That depends on the page size, but it is approximately
(page_size - 20) ^^3

> can we use some 'seek'
>inside a BLOB? I saw something like that in the .h but not in the
>documentation

That requires creating a stream blob which hasn't been documented
in years. I don't know if it works.

>- can I reuse a BLOB? i.e., insert several raws putting same
>ISC_QUAD (==BLOB ID) in a given column ?

No. Part of storing a blob is changing it from temporary to
permanent. Once a blob has been stored, the temporary id no
longer exists.

Regards,


Ann