RE: Change varchar column
How did you measure space used?
Engine version?
Schema?
oncheck -pt output (before and after)?
> -----Original Message-----
> From: owner-informix-list@iiug.org
> [mailto:owner-informix-list@iiug.org]On Behalf Of Obnoxio The Clown
> Sent: Thursday, 18 December 2003 6:28 a.m.
> To: informix-list@iiug.org
> Subject: Re: Change varchar column
>
>
> Mark wrote:
>
> > Dear all,
> >
> > During a table schema migration task, I unloaded data from
> a table, drop
> > the table and re-create the table with changed some column from
> > varchar(10) to varchar(255), then re-load the original data
> back to the
> > new table.
> >
> > We found space used increased from 1GB to 1.5GB for that table.
> >
> > Anyone know why.
>
> It's hard to tell from this angle.
>
> Perhaps there is a different minimum size to the column or
> something?
>
> --
> "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule"
> - Coluche
sending to informix-list