Re: Description fields in Informix databases

--Boundary_(ID_RpQD+FKrLma5uhmiFKvQfA) Content-type: text/plain; charset=us-ascii Content-disposition: inline Content-transfer-encoding: 7BIT Lauri Try using TEXT datatype. HTH Sujit Lauri Pietarinen <lauri.pietarinen@atbusiness.com> on 12/29/99 02:13:38 AM Please respond to Lauri Pietarinen <lauri.pietarinen@atbusiness.com> To: informix-list@iiug.org cc: (bcc: Sujit Pal) Subject: Description fields in Informix databases --Boundary_(ID_RpQD+FKrLma5uhmiFKvQfA) Content-type: text/plain; charset=iso-8859-1 Content-disposition: inline Content-transfer-encoding: quoted-printable As Informix does not support varchar-fields over 255, how would you recommend saving descriptions, that usually are under 255 but sometimes can be over 1 K long. Using a fixed 2K field is a possibility, but it does waist a lot of space. I would be most grateful for any suggestions. Lauri Pietarinen -- =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Lauri Pietarinen tel +358-9-2534 4632 AtBusiness Communications Oy fax +358-9-2534 4601 It=E4lahdenkatu 19 mob +358-50-594 2011 00210 HELSINKI mailto:lauri.pietarinen@atbusiness.com Finland http://www.atbusiness.com =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D = --Boundary_(ID_RpQD+FKrLma5uhmiFKvQfA)--