Subject Re: [ib-support] Maximum size of a Firebird BLOB field
Author Ann W. Harrison
At 12:46 AM 12/6/2002 +0800, Jon Perez wrote:
>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.

No, not at all. The maximum size of a blob depends
somewhat on page size. Large blobs are stored through
a two level index. The highest level is an array of
pointers to the second level index pages. The second
level pages point to actual blob pages. Blobs can be


We have answers.