Re: position of VARCHAR in the table

Ravi Hubbly wrote: > > Hi, > > In other databases the position of VARCHAR in the table effects the table = > size. If the VARCHAR = > data type is defined in between the other data type fields then no benefit o= > f = > space saving occurs. = > To get this benifit the VARCHAR fields are to be specified as the last field= > s. = That's terrible! > Is this true even incase of INFORMIX? If not then why is INFORMIX different = > = > from the other database? No. The only overhead with VARCHAR in Informix is 1 byte for the length. The growth AND shrinkage of a VARCHAR is handled automatically by Informix. If Informix told you the difference then all the other databases would be doing it! :-) Cheers, -- Mark. +-------------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | | |mailto:marks@west.co.za +------------------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work... force it! | |Fax: +27 11 803 2189 |If it breaks... it needed replacing anyway! | |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+------------------------------------------------+