Subject | How varchar columns are stored in FB? |
---|---|
Author | Da Jiao |
Post date | 2004-03-18T20:19:01Z |
Hi,
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.
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.