Subject Using <> and/or IS DISTINCT FROM with BLOB columns
Author Thomas Steinmaurer

I vaguely remember starting with a particular Firebird version, that the
<> operator can be used on BLOB data to compare old and new BLOB data in
an AFTER UPDATE trigger.

Is the <> operator supposed to work on BLOB columns? If yes, for both,
SUB_TYPE 1 *and* 0? If so, starting with what version?

How about IS DISTINCT FROM on BLOB columns?


Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
My blog: