SQLite Forum

sqlar: is it reliable to use length(sqlar.blob)==sqlar.sz determine whether the data is compressed
Login
I am not asking how the code works.

I am asking why it makes sense when length(sqlar.blob)==sqlar.sz, there is no compression, when length(sqlar.blob)<sqlar.sz there is compression?

Is it possible that length(sqlar.blob)>sqlar.sz given the header/checksum can increase the length?