Re: Question on Lvarchar Datatype

I would suggest sticking with LVARCHAR as with 9.4 the max length has gone up to 32K for this data type. This will also make your queries cleaner ...as for performance, I think both would be same ...but the best part is that you don't have to worry about the column length hitting the max size of 255 all the time ..:-) Thanx much, Rajib Sarkar Advisory Software Engineer (RAS) IBM Data Management Group Ph : (602)-217-2100 Fax: (602)-217-2100 T/L : 667-2100 As long as you derive inner help and comfort from anything, keep it -- Mahatma Gandhi kalpanapai@hotmai l.com To: informix-list@iiug.org (KalpanaPai) cc: Sent by: Subject: Question on Lvarchar Datatype owner-informix-li st@iiug.org 09/14/2003 09:24 PM Please respond to kalpanapai Hi Could naybody clarify me , which is the best datatype to use VARCHAR or LVARCHAR? I need to store data like Comments could be less than 255 or > 255 . Is it better to use more than one VARCHAR(255) columns or LVARCHAR? LVARCHAR is variable length, is it same as VARCHAR ie will it store only 100 chars if i input 100 , will it not pad up the blank spaces for storage and comparision? Is there any peroformance issue if we use LVARCHAR instead VARCHAR in queries? Any help much appreciated Thanks Kalpana sending to informix-list