Alan,

> do you still not declare that subtype in your parameter list? I've found
> this problematic.

Can't confirm.

I haven't added the subtype declaration in the parameter list (so far).

I must admit that the blob input parameter is only used within an INSERT INTO
statement then, inserting into a column which is based on subtype 0, so
independent what blob data is coming through, the inserted blob is always
stored in a subtype 0.

And, someone has mentioned in the past that with Firebird blob data within
a trigger can be directly compared using OLD.BLOBCOLUMN<>NEW.BLOBCOLUMN, so
the use of a UDF should be unnecessary. Though, I haven't tried it.


Thomas.