Subject Re: [firebird-support] Blobsize definition?
Author Ann W. Harrison
Andi Voss wrote:
> Hi,
>
> is someone able to explain the blobsize to me?
> Why is the Blobsize limited to 4Gbyte when the dps is about 4kbytes?
> How is the calculation step to this result?

Because in a number of places in the engine and utilities, people have
made the mistake of using a 32 bit integer as the byte length of the
blob. The result is that larger blobs will be truncated on restore,
fail to work with blob seek operations (on stream blobs) and a half
dozen other annoying things. And yes, this all will be fixed, but I
don't know when.


Regards,


Ann