Subject How varchar columns are stored in FB?
Author Da Jiao

This is a newbie question. How VARCHAR columns are stored in FB? If I have a
varchar(6000) column but most of the time the real data are less than 300 in
length, will FB pad the unused space?

Or put it in another way, For a varchar(6000) column, will a string of 300
characters occupy the same store space as a string of 5000 characters in FB?
I of course hope that shorter string will take less space but is that what
FB doing?

Note I am not talking about transporting varchar between client and server
for I know FB 1.5 support the compact form of varchar now.

Thank you.