Subject Re: [firebird-support] Varchar size overhead
Author Dmitry Yemanov
Richard Wesley wrote:
> This sounds like the contents of each record is compressed, BUT each
> record still takes a fixed (maximal) amount of space on disk?

Nope, it wouldn't make any sense. The record is expanded (up its maximum
length) in memory but always RLE-compressed on disk.

The point of my message was that it's the entire record what is
compressed, not particular columns. So we cannot just ignore the
trailing zero bytes for VARCHARs, we have to compress them as well.