Subject BLOB ID value of 0, 0 means empty or is that a corrupt value?
Author IBO Support List

How does the Firebird engine treat a situation where a XSQLVAR has its null indicator to NOT NULL and it has a BLOB ID of 0, 0.

Does it just treat it as an empty blob or will it cause an error of some kind?

I have written some low level apps that entered these types of values into the database and there was no error, but I’m wondering if there should be or if this is an efficient way to indicate that the BLOB is empty rather than NULL.


Thanks for those who know the internals who can shed some light on this for me.


Kind regards,

Jason Wharton