Re: SQL - Create table Stmt

["Mark S. Waterbury" <mark.s.waterbury@xxxxxxx>]

Hi, Joe, and Wes:

That's not just a good guess, it is absolutely true. 

Cheers,

Mark S. Waterbury

> Joe Pluta wrote:
> Quick guess: VARCHARs require an extra two bytes to store the length of the
> data in the field.
>
> Joe
>
>   
> > From: Wes
> >
> > I'm creating a SQL table using the follwoing SQL statment...
> >
> > Create table F55RULE (
> > RUGROP VARCHAR(50) NOT NULL,
> > RULOB VARCHAR(3),
> > RULT VARCHAR(3) NOT NULL,
> > RUVALR VARCHAR(1) NOT NULL,
> > RUOBJS VARCHAR(6) NOT NULL,
> > RUSUBS VARCHAR(8) NOT NULL,
> > RUOBJE VARCHAR(6),
> > RUSUBE VARCHAR(8) NOT NULL);
> >
> > Once the table is created though, the size of each column had been
> > expanded
> > by 2 char...
> >
> > FIELD     Position    Length  D Ty. File      Libra
> > RUGROP          1         52  0  A  F55RULE   QGPL
> > RULOB          53          5  0  A  F55RULE   QGPL
> > RULT           58          5  0  A  F55RULE   QGPL
> > RUVALR         63          3  0  A  F55RULE   QGPL
> > RUOBJS         66          8  0  A  F55RULE   QGPL
> > RUSUBS         74         10  0  A  F55RULE   QGPL
> > RUOBJE         84          8  0  A  F55RULE   QGPL
> > RUSUBE         92         10  0  A  F55RULE   QGPL
> >
> > Does anybody know why this is?
> >     
>
>
>