Informix-data type

Posted in 2000

Usha M Rao — Wed, 23 Feb 2000 09:52:53 — source: Informix-list mailing list archive (1991-1998)

I am using Informix Version 7.3. I want to define a varying length column,which takes upto 2000 characters Since NChar datatype is a fixed length character data type,I donot want to use that. I cannot define LVarchar .How can I resolve this problem? Usha

↪ replying to Usha M Rao

fabioantunes@my-deja.com — Wed, 23 Feb 2000 12:46:32 GMT — source: Informix-list mailing list archive (1991-1998)

In article <88vons$1uj$1@news.xmission.com>, "Usha M Rao" <usha_mr@trigent.com> wrote: > > I am using Informix Version 7.3. I want to define a varying length > column,which takes upto 2000 characters Since NChar datatype is a fixed > length character data type,I donot want to use that. > I cannot define LVarchar .How can I resolve this problem? > > Usha > > How About datatype text regards, -- F'bio Antunes Fanix Consultoria Ltda. Brasil - SP Sent via Deja.com http://www.deja.com/ Before you buy.

↪ replying to Usha M Rao

Jonathan Leffler — Fri, 25 Feb 2000 11:59:26 -0800 — source: Informix-list mailing list archive (1991-1998)

Usha M Rao wrote: > I am using Informix Version 7.3. I want to define a varying length > column,which takes upto 2000 characters Since NChar datatype is a fixed > length character data type,I donot want to use that. > I cannot define LVarchar .How can I resolve this problem? Upgrade to a server which has LVARCHAR, meaning 9.2 these days, though 9.0x and 9.1x also support them. -- Yours, Jonathan Leffler (Jonathan.Leffler@Informix.com) #include Guardian of DBD::Informix v0.95 -- http://www.perl.com/CPAN "Windows is NOT a virus: a virus is small and efficient."