|Subject||Re: [ib-support] trigger on a blob field|
> - using UDF should work for both IB/FB, and Null state of blobIt should be easy task, just few rows of code.
> column can be tested directly in UDF
> err - anyone done a UDF for this??
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 ...