Subject Re: [firebird-php] Firebird blank spaces on unused chars in a field?
Author Lester Caine wrote:

> 1. If this is the case, does this mean that, if I declare a field of
> 50 chars, even if i don't use them all, each record will consume 50 bytes?

CHAR stores all the spaces.
VARCHAR stores a size (two byte) + the space used.

Client tools work differently on returning the information, but 'on the
wire' VARCHAR used to be expanded to full size - not sure if that is the
case still or to be changed in FB2.

> 2. Is there a work around so that the other free spaces are not used up?

What is stored is compressed - what is displayed depends on you ;)

Lester Caine
L.S.Caine Electronic Services