Varchar lengths

Posted in 2000

Richard Krenek — Mon, 11 Sep 2000 20:23:17 GMT — source: Informix-list mailing list archive (1991-1998)

Hello all, I have a simple question. Currently we have Informix (IDS Workgroup ED) version 7.30. We are limited to the size of a varchar, 255 I think. In later versions is this still a limit. Thanks, Rich

↪ replying to Richard Krenek

Art S. Kagel — Mon, 11 Sep 2000 16:49:49 -0400 — source: Informix-list mailing list archive (1991-1998)

IDS 9.2x implements VARCHAR2 which has a limit of 32767 characters the same as CHAR. Art S. Kagel Richard Krenek wrote: > > Hello all, > I have a simple question. Currently we have Informix (IDS Workgroup > ED) version 7.30. We are limited to the size of a varchar, 255 I think. > In later versions is this still a limit. > > Thanks, > Rich

↪ replying to Art S. Kagel

Xavier Trevisani — Tue, 12 Sep 2000 02:03:19 GMT — source: Informix-list mailing list archive (1991-1998)

"Art S. Kagel" <kagel@bloomberg.net> wrote in message news:39BD456D.95C66E3A@bloomberg.net... > IDS 9.2x implements VARCHAR2 which has a limit of 32767 characters the same > as CHAR. > > Art S. Kagel Is varchar2 in 9.20 ? I do not see it in the documentation ... I will try it in the morning xavier > > Richard Krenek wrote: > > > > Hello all, > > I have a simple question. Currently we have Informix (IDS Workgroup > > ED) version 7.30. We are limited to the size of a varchar, 255 I think. > > In later versions is this still a limit. > > > > Thanks, > > Rich

↪ replying to Xavier Trevisani

Art S. Kagel — Tue, 12 Sep 2000 11:51:08 -0400 — source: Informix-list mailing list archive (1991-1998)

Sorry, bad day. That should be LVARCHAR I believe and the max for LVARCHAR is 2K not 32K. ARRGGHH! Art S. Kagel Xavier Trevisani wrote: > > "Art S. Kagel" <kagel@bloomberg.net> wrote in message > news:39BD456D.95C66E3A@bloomberg.net... > > IDS 9.2x implements VARCHAR2 which has a limit of 32767 characters the > same > > as CHAR. > > > > Art S. Kagel > > Is varchar2 in 9.20 ? I do not see it in the documentation ... I will try > it in the morning > > xavier > > > > > Richard Krenek wrote: > > > > > > Hello all, > > > I have a simple question. Currently we have Informix (IDS Workgroup > > > ED) version 7.30. We are limited to the size of a varchar, 255 I think. > > > In later versions is this still a limit. > > > > > > Thanks, > > > Rich

↪ replying to Art S. Kagel

Jonathan Leffler — Wed, 13 Sep 2000 06:42:17 GMT — source: Informix-list mailing list archive (1991-1998)

"Art S. Kagel" wrote: > Sorry, bad day. That should be LVARCHAR I believe and the max for LVARCHAR > is 2K not 32K. ARRGGHH! > It should indeed be LVARCHAR, and the storage limit is indeed 2 KB (for reasons that have never been clear to me). The LVARCHAR data type can actually contain up to 32 KB for transporting data types back and forth between application and server, but the storage for an LVARCHAR as an LVARCHAR is indeed limited to 2 KB. VARCHAR2 is an Orrible type. > Xavier Trevisani wrote: > > "Art S. Kagel" <kagel@bloomberg.net> wrote: > > > IDS 9.2x implements VARCHAR2 which has a limit of 32767 characters the same > > > > as CHAR. > > > > Is varchar2 in 9.20 ? I do not see it in the documentation ... I will try > > it in the morning > > > > > Richard Krenek wrote: > > > > I have a simple question. Currently we have Informix (IDS Workgroup > > > > ED) version 7.30. We are limited to the size of a varchar, 255 I think. > > > > In later versions is this still a limit. -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v1.00.PC1 -- see http://www.perl.com/CPAN #include <disclaimer.h>