freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

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

From: Dirk Koopman <freetds AT tobit.co.uk>
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 09:53:34 +0000

On Fri, 2005-02-11 at 09:38 +0000, James Vanns wrote:
> Just my tuppence really but its not a stupidly low value in freetds.conf
> is it!?
>
> 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.
>

I will try it. But it is important to understand that it is a *write*
problem, not read. I have done a "set textsize = 65535" as well.

Dirk

[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