freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

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

From: "James K. Lowden" <jklowden AT schemamania.org>
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 10:10:35 -0500

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....

--jkl

[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