Steffen Heil wrote:

>>You should not try to insert text longer than 32,765 bytes
>>into a blob using a string as input. If IBExpert lets you
>>insert longer strings, then IBExpert has a bug that will
>>cause an overflow exception in the database.
>
> I do not understand this.
> What is blob subtype text then for? If not for long strings?
> How should we handle those?
> I do not want to transform my texts into byte arrays and store those...

The problem depends on your interface TO the blob. Some of the client
tools allow strings in the tool loaded from the blob, but they impose
the limits Sebastico is seeing. If you use stream or file interfaces,
then there is no limit. I dump files direct to the fields, but the
viewer program only 'sees' the first 32,765 characters ;)

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services