| Subject | BLOB ID value of 0, 0 means empty or is that a corrupt value? |
|---|---|
| Author | IBO Support List |
| Post date | 2017-08-10T21:53:13Z |
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