--- In firebird-support@yahoogroups.com, "Ann W. Harrison"
<aharrison@i...> wrote:

> mikcaau wrote:
> >
> >
> > Put a maxsize VarChar field in your table.
> > Compress email before saving it.
> > If compressed size < VarChar field size (~32k) then save into varchar
> > field, else save to blob.
> > Note that blobs are not compressed during backup
>
> If you do that, and I wouldn't, be sure your varchar is type OCTETS.
> You don't want your compressed string to be extended with spaces or
> truncated at a null.
>
>
> Regards,
>
>
> Ann

Anne,
Thanks for advice.
Would you suggest email body into VarChar unless it is too big in
which case compress and store in blob?

Mick