Re: Informix character type- URGENT

>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