Subject Re: [ib-support] How to detect BLOB changes in a Trigger
Author Jörg Schiemann
> > Thanks Markus,
> >
> > too bad.
> > do you know, if it's the same with firebird?
>
> You can compare blobs with FB, but DON'T DO THAT. The comparison will
return
> FALSE if you have more than one segment in any blob or if the segments
begin
> compared have different size. You will be fooled.
>
> C.
> --
> Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
> Independent developer
> Owner of the Interbase® WebRing

IMHO it should be better to disable the comparison of BLOBS in FB.
It's too easy to do wrong with the current solution if you don't know that.

Do you know if there are any plans for BLOB comparison with more than one
segment in the future?

Only my 2 cents.

Thanks,
Jörg