At 05:16 AM 4/20/06, Markus Schaber wrote:
>Hi, Louise,
>
>Louise Catherine wrote:
>
> > Could anyone explain, why the field length must be add by 4 :
> > result 1 : 10 + 4 =14
> > result 2 : 5 + 4 = 9
>
>I guess that it is because all variable length datatypes (and text types
>are such) internally contain a 4 bytes length field.
Except that the original fields were neither variable length datatypes, not
type text.
create table test(]
satu char(10),
dua char(5)
);