Re: Source size and how to change

From: Mark J. McGinty (mmcginty_at_spamfromyou.com)
Date: 04/25/04 

Date: Sat, 24 Apr 2004 23:00:04 -0700

That's not ADO, those are limits of SQL types nvarchar and varchar
respectively. Also there is a limit of 8060 bytes per row, not counting
text, ntext or image types. So if you need to move more than that in a
recordset, you must use one of the 'long' types mentioned above.

-Mark

"Jerry Pisk" <jerryiii@hotmail.com> wrote in message
news:uyIJdUcKEHA.4052@TK2MSFTNGP11.phx.gbl...
> Actually it does, depending on your settings ADO will truncate strings at
> 4000 or 8000 characters. The first is when using Unicode strings (the
> default), the second when using ASCII strings.
>
> Jerry
>
> "Val Mazur" <group51a@hotmail.com> wrote in message
> news:%23uZC9TaKEHA.4052@TK2MSFTNGP11.phx.gbl...
> > Hi,
> >
> > It should not truncate sql string. I am using pretty big one in some
cases
> > and it works fine. What is your query looks like and how do you know
that
> > string was truncated. Do you get any error?
> >
> > --
> > Val Mazur
> > Microsoft MVP
> >
> >
> > "TLowe" <noelbisspam@nomindspringspam.com> wrote in message
> > news:eraMmvUKEHA.1156@TK2MSFTNGP09.phx.gbl...
> > > Hello all!
> > > I have a question about the size of a string that can be passed as the
> > > source in an ADO call. Here is recordset that I am trying to open.
> The
> > > problem is the variable (strSQL) holding the sql statement is
truncating
> > > the
> > > statement. It must be happening in the ADO call because the actual
> > > variable
> > > has the correct value. How do I change the size of the ADO source so
> > > that
> > > it will allow my whole sql statement to be passed?
> > >
> > > Thanks for any help!
> > >
> > > Tom
> > > Here is the ADO call
> > > rs.Open strSQL, cnnConnection, adUseClient, adLockReadOnly
> > >
> > >
> > >
> > >
> > >
> >
> >
>
>

Relevant Pages

  • Re: int/long unification hides bugs
    ... I rewrote your post, using long strings instead of large numbers, to ... Your mention of lists, in fact, shows exactly how specious your ... badly thought out, weak, and totally useless in the first place. ... of the _default_ nature of the limits. ...
    (comp.lang.python)
  • Re: [Ext2-devel] [RFC] [PATCH] Reducing average ext2 fsck time through fs-wide dirty bit]
    ... There are limits to the size of a single journal transaction ... truncate needs to zero ...
    (Linux-Kernel)
  • Re: Source size and how to change
    ... depending on your settings ADO will truncate strings at ... >> it will allow my whole sql statement to be passed? ...
    (microsoft.public.data.ado)
  • Re: can i extend the default limit of 256 bytes on memo fields?
    ... that will truncate long text strings to 255 characters. ... action/method; it will not truncate long text strings. ... warning messages of field truncation on my memo-type field. ...
    (microsoft.public.access.externaldata)
  • Re: Fastest way to append text to a TextBox
    ... strings around in memory? ... If I truncate the StringBuilder after it's transferred its data into the TextBox, it's even faster still! ... OK, I may not get all the benefit of this (my colour coding the output means I'll have to group lines of the /same/ colour together into a single RichTextBox update) but, even so, it's hugely faster than before. ...
    (microsoft.public.dotnet.languages.vb)