Varchar lengths
Posted in 2000
Richard Krenek asked whether the 255-character VARCHAR limit in IDS 7.30 is larger in later versions. Art Kagel first cited VARCHAR2 with a 32767 limit, then corrected himself to LVARCHAR. Jonathan Leffler confirmed LVARCHAR stored as such is limited to 2 KB, though it can carry up to 32 KB when moving data between application and server. Xavier Trevisani could not find VARCHAR2 in the documentation.
Topics: Data Types & Schema Design
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
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
"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
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
"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>