Max Characters SQL Statement

Posted in 1999

Cook, Russell L — Tue, 17 Aug 1999 08:51:21 -0700 — source: Informix-list mailing list archive (1991-1998)

What is the maximum number of characters a single sql statement may contain? Appreciate your help. Thanks in advance Russell L. Cook Marconi Integrated Systems, Inc (858) 592-5008 russell.cook@Marconi Integrated Systems, Inc

↪ replying to Cook, Russell L

Art S. Kagel — Tue, 17 Aug 1999 12:55:40 -0400 — source: Informix-list mailing list archive (1991-1998)

"Cook, Russell L" wrote: > > What is the maximum number of characters a single sql statement may contain? > Appreciate your help. Thanks in advance At this point, Russell, no one is certain (check out Jonathan Leffler's reply to "What's the maximum number of columns in a table?"). There used to be a 32K limit but that is being raised in the 7.3x series and later, however, it may be 256K or 2GB or unlimited now. Anyone in Menlo Park or Lenexa lurking about want to research this one, besides Jonathan, give the guy a break, eh! Art S. Kagel

↪ replying to Art S. Kagel

Robert & Debbie Fetter — Wed, 18 Aug 1999 21:59:00 -0400 — source: Informix-list mailing list archive (1991-1998)

"Art S. Kagel" wrote: > "Cook, Russell L" wrote: > > > > What is the maximum number of characters a single sql statement may contain? > > Appreciate your help. Thanks in advance > > At this point, Russell, no one is certain (check out Jonathan Leffler's > reply to "What's the maximum number of columns in a table?"). There used > to be a 32K limit but that is being raised in the 7.3x series and later, > however, it may be 256K or 2GB or unlimited now. Anyone in Menlo Park or > Lenexa lurking about want to research this one, besides Jonathan, give > the guy a break, eh! > > Art S. Kagel I can say with confidence that 64K is the limit with 4.23. Hopefully, this (arbitrary) limitation is being lifted in later versions.