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