Question on Lvarchar Datatype

Posted in 2003

KalpanaPai — 14 Sep 2003 21:24:54 -0700 — source: Usenet: comp.databases.informix

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