Subject | Re: [ib-support] Maximum size of a Firebird BLOB field |
---|---|
Author | Daniel Rail |
Post date | 2002-12-05T17:32:11Z |
JP> The Interbase 6.0 factsheet says that:
JP> Maximum row size (excluding BLOB): 64Kb
JP> Does this mean it is possible to store an
JP> object in a BLOB column that exceeds 64KB?
Yes.
JP> What is the maximum size of such an object?
I don't think that there is a limit, except the limitation of the
database file which can be 2GB and up. I have blobs that are over 2MB
in size(high-resolution image scans).
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)
JP> Maximum row size (excluding BLOB): 64Kb
JP> Does this mean it is possible to store an
JP> object in a BLOB column that exceeds 64KB?
Yes.
JP> What is the maximum size of such an object?
I don't think that there is a limit, except the limitation of the
database file which can be 2GB and up. I have blobs that are over 2MB
in size(high-resolution image scans).
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)