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

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 (AT) iiug (DOT) org
(KalpanaPai) cc:
Sent by: Subject: Question on Lvarchar Datatype
owner-informix-li
st (AT) iiug (DOT) 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