Subject Re: [ib-support] trigger on a blob field
Author Ivan Prenosil
> - using UDF should work for both IB/FB, and Null state of blob
> column can be tested directly in UDF

> err - anyone done a UDF for this??

It should be easy task, just few rows of code.
The hardest part is deciding when are blobs considered equal.
Because blobs are by default segmented, what do you expect here:
- first blob consisting of one segment 'abcd'
- second blob consisting of two segments 'ab' and 'cd'
Are they equal ?

FB treats them as different (which sounds reasonable to me);
however, with most access components you do not have control
over dividing data into segments ...

Ivan
http://www.volny.cz/iprenosil/interbase