it's my understanding that you can't use comparison operators on blobs, only
LIKE, STARTING and CONTAINING.

Kind regards,
Pete

Yosvany Llerena Rodriguez said

> Ok, sendme the full code of the trigger
>

jef said

> > Hi everybody,
> >
> > I have a table with a blob field (a text one).
> > I want to make a before update trigger to test if the blob field was
> modified.
> > I tried a test : new.field <> old.field but it doesn't work (blob fault
> ?).
> >
> > Is there somebody who have an idea ?
> >
> > Thanks.