RE: Using Varchar

Posted in 2000

Demus, Alan — Thu, 9 Mar 2000 14:49:36 -0600 — source: Informix-list mailing list archive (1991-1998)

Speaking of lvarchar, I'm having a lousy time trying to retrieve a lvarchar column in a 4GL program -- it obviously doesn't understand a straight SELECT, but it also bombs on a PREPARED statement. How can I do this? > -----Original Message----- > From: Rob Wilson [SMTP:rwilson@ntsource.com] > Sent: Thursday, March 09, 2000 1:30 PM > To: informix-list@iiug.org > Subject: Re: Using Varchar > > Nuno Andri (na.airc@esoterica.pt) wrote: > : Is there any limitation on using the datatype varchar? > : Can we use it in any former char columns or only for those column that > have > : more than a certain number of chars? > > > : Thanks for your help, > > Sure, limited to 255 bytes. Otherwise you _can_ use it on a column > that was defined as a char(<255) but it may not perform as quickly. > > If you are on 9.2 or better you get lvarchar (which gives you a > whoooole bunch of characters).