If does, how to avoid it?
asked 07 Jun '16, 14:41
You will find SQL Anywhwere tries to save you storage space whenever possible. Unlike some other database technologies, with SQL Anywhere, LOBs will not allocate extra 'blob' pages unless required. There are a few layers to this.
The simplest case is the Null value case which Mark has covered already. I.E. NO extra space.
The 2nd layer, there is a space savings for short LOBs if they are less than the INLINE size, they are store inside your row and will not use blob pages. This can save you lots of space (in comparison to some other implementations) if most of your LOBS are small. This is true of you zero-length (ie. empty) LOB case; we need to store the length byte for those and that's it.
And there are other aspects of LOB storage you might want to also be aware of.
answered 07 Jun '16, 15:22
Nick Elson S...
A NULL column of any type only takes up 1 bit in the row header.
answered 07 Jun '16, 14:54