SQLite Forum

sqlar: is it reliable to use length(sqlar.blob)==sqlar.sz determine whether the data is compressed
I can see no reason to update that doc. It plainly says, "The file is compressed if length(sqlar.blob)<sqlar.sz and is stored as plaintext if length(sqlar.blob)==sqlar.sz."  The commentary regarding compressed storage format details does not contradict that plain statement and can most sensibly be read as being additional detail rather than an exception.  To block your strained over-interpretation would take additional verbiage which would only dilute the content for most readers, or cause them to wonder why it needed saying.