Re: Informix character type- URGENT

Rajesh Puri wrote: > > I am trying to set up a table whuch needs char(1000). Does it mean > DB will store 1000 bytes in DB, even though I might input only 100?. Yes! it does occupy 1000 bytes irrespective of whethere you use full, part or none of the field. > I suspect this to be right, since only VARCHAR kind only takes off Beware there is a trade-off between the size and considerable overhead on the server, as was mentioned many a time in the postings here. > trailing spaces. Anyone has definte answer on this. It is INFORMIX 7.0. > Thanks. -- \\\\|// Vijay R. Anisetti |6 6| -------------------oooO--U--Oooo----------------------------