Subject Re: [firebird-support] Blob Problem
Author Helen Borrie
At 08:57 PM 31/01/2005 -0200, you wrote:

>I have an archive txt with approximately 7200 bytes and desire to
>store its content in a field blob of one determined table in my
>system. This archive txt approximately possesss 20160 lines with
>an approach size of 361 characters for line. What it occurs is
>that when I try to insert the content of the archive txt for
>the field blob only the 203 first lines are recorded, what
>corresponds to an approach size of 65739 bytes.

This will be a bug with your client program. Are you using the BDE?

>The size of the block of the data base is defined in 16KB and
>is using BLOB SUB_TYPE 1 SEGMENT SIZE 2048.

Blob segment size doesn't matter.

>Somebody that it
>has experience with firebird could inform me where sub_type
>of field BLOB I will be able to store this content of the archive?

Use BLOB SUB_TYPE 1 for text.

Notice also that it is possible, in a dynamic SQL statement, to pass a
string of 32565 bytes as input to a text blob. Anything larger, and your
program must pass a blob. Firebird itself does not limit the size of a blob.

Give some details of the programming environment, and someone may be able
to offer suggestions about what you need to do to correct the 64Kb limit
that you are encountering.