Subject Re: [firebird-support] Varchar size overhead
Author Dmitry Yemanov
Hannes Streicher wrote:
>
> from my understanding of VARCHAR it uses a pascal-string like storage
> with a stringlength , instead of the CHAR which is space padded ,
> so if the varchar is filled with 32 characters
>
> there are no bytes needing to be Run length compressed after these 32
> chars as opposed to char which is space padded and thf can be RL
> compressed

The entire record is RL compressed as a whole. And the record has has a
fixed format, i.e. every column is represented with its maximum length.


Dmitry