| Subject | Re: [Firebird-Architect] BLOB ID value of 0, 0 means empty or is that a corrupt value? |
|---|---|
| Author | James Starkey |
| Post date | 2017-08-10T23:44:40Z |
Around the dawn of JRD time, it would throw an error. 0,0 isn't a blob id and I wasn't inclined to be forgiving.
On Thu, Aug 10, 2017 at 5:53 PM 'IBO Support List' supportlist@... [Firebird-Architect] <Firebird-Architect@yahoogroups.com> wrote:
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
--
Jim Starkey