freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: [freetds] insert varchar/text fields limited to max 80 characters

From: Frediano Ziglio <freddyz77 AT tin.it>
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Subject: Re: [freetds] insert varchar/text fields limited to max 80 characters
Date: Fri, 11 Feb 2005 16:46:29 +0100

Il giorno ven, 11-02-2005 alle 10:10 -0500, James K. Lowden ha scritto:
> James Vanns <jimv AT canterbury.ac.uk> wrote:
> >
> > There is a default block size:
> >
> > [global]
> > # TDS protocol version
> > tds version = 8.0
> > initial block size = 1024
> >
> > I know nothing about dblib or perl but I do know I have had a similar
> > problem in the past where the block size was to small for what was being
> > retrieved.
>
> "initial block size" will not have any effect on the reported problem.
>
> It affects the size of TDS packets, roughly similar to the MTU in tcp/ip.
> Larger packets mean fewer packets (and fewer round trips to the server),
> but also a larger recovery unit in the event of a lost/damaged packet.
>
> I suspect the problem lies somewhere in ct-lib. First step would be to
> create a (broken) test case. Well, step zero would be to test with
> RC10....
>

Mmm... easier... if 0.62.4 contains rebindpar test (under
src/odbc/unittests) it do not truncate... if not it truncate... Fixed
many time ago in 0.63. 0.63 support much better DBD::ODBC. Current 0.64
support even better (only a sub test fails... cursors...)

freddy77

[freetds] insert varchar/text fields limited to max 80 characters, Dirk Koopman, 02/10/2005
- RE: [freetds] insert varchar/text fields limited to max 80 characters, Piet De Jong, 02/11/2005
- <Possible follow-up(s)>
- [freetds] insert varchar/text fields limited to max 80 characters, Dirk Koopman, 02/10/2005
  - Re: [freetds] insert varchar/text fields limited to max 80 characters, James Vanns, 02/11/2005
    - Re: [freetds] insert varchar/text fields limited to max 80 characters, Dirk Koopman, 02/11/2005
      - RE: [freetds] insert varchar/text fields limited to max 80 characters, Piet De Jong, 02/11/2005
        
        RE: [freetds] insert varchar/text fields limited to max 80 characters, Dirk Koopman, 02/11/2005
    - Re: [freetds] insert varchar/text fields limited to max 80 characters, James K. Lowden, 02/11/2005
      - Re: [freetds] insert varchar/text fields limited to max 80 characters, Frediano Ziglio, 02/11/2005
        
        Re: [freetds] insert varchar/text fields limited to max 80 characters, Dirk Koopman, 02/14/2005
- RE: [freetds] insert varchar/text fields limited to max 80 characters, ZIGLIO, Frediano, VF-IT, 02/15/2005