Subject Re: [ib-support] Maximum size of a Firebird BLOB field
Author Martijn Tonies
Hi,

> The Interbase 6.0 factsheet says that:
>
> Maximum row size (excluding BLOB): 64Kb
>
> Does this mean it is possible to store an
> object in a BLOB column that exceeds 64KB?
> What is the maximum size of such an object?
>
> Reading past messages on this group gave
> me the impression that since the maximum
> size of a row is 64KB, the maximum size
> of a BLOB column will be 64KB or less.

BLOBs can be GBs in size. At each row, a blob-column
will store a blob-pointer. That is a pointer to a special
blob-area in the database...


With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase
http://www.upscene.com

Firebird Workbench - the developer tool for Firebird
http://www.upscene.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."