[SQL] Re: blobs and small binary objects

[David Wall]

I discovered type OID in the JDBC sample database for BLOBs, but I don't see
it in the documentation.

>From a quick test, it appears that the blob itself is not stored in the row
itself, but is instead an object pointer of some kind.  Is an OID actually a
fixed length field that points to my blob?  Or is it more like a VARCHAR, in
which case it would be better to store it at the end of the row for storage
performance reasons?

David