| Subject | Re: [firebird-php] Firebird blank spaces on unused chars in a field? |
|---|---|
| Author | Lester Caine |
| Post date | 2004-11-23T11:03:24Z |
ArnoldGamboa.com wrote:
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.
--
Lester Caine
-----------------------------
L.S.Caine Electronic Services
> 1. If this is the case, does this mean that, if I declare a field ofCHAR stores all the spaces.
> 50 chars, even if i don't use them all, each record will consume 50 bytes?
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