RE: Informix character type- URGENT

Rob, The (2k or 4k) page size is resolved if he/she creates a BLOB space to store the TEXT field, when creating the BLOB space you can specify the PAGE SIZE. Regards, Mario Estrada --------Reply Separator-------- ---------- From: Rob J McAllister[SMTP:rmcall@on-ramp.ior.com] Sent: Sunday, July 20, 1997 1:23 AM To: informix-list@rmy.emory.edu Subject: Re: Informix character type- URGENT Don't forget that type TEXT uses disk a page at a time. Database pages are typically 2K or 4K. If you are planning to use up to 1000 bytes, type TEXT is a bad choice. Why VARCHAR is so limited, I can't say, but what about splitting your data into 4 VARCHAR(255) columns ? Would this work in you case ? What is more important Space or Time ? satriguy@aol.com (SaTriGuy) 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?. >>I suspect this to be right, since only VARCHAR kind only takes off >>trailing spaces. Anyone has definte answer on this. It is INFORMIX 7.0. >>Thank >Yep - a CHAR is a fixed length data type. You might want to consider >making this a TEXT type >Madison Pruet