Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Piet De Jong" <piet AT ahead-tech.net>
  • 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 14:34:38 +0200

Dirk this is what I use:
# dealing with text columns
$dbh->do ( " set TEXTSIZE 2147483647 " );
$dbh->{'_DB'}->{LongReadLen} = 10 * 1024;
$dbh->{'_DB'}->{LongTruncOk} = 1;

Works for me, hope it helps.
Piet


> -----Original Message-----
> From: freetds-bounces AT lists.ibiblio.org
> [mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Dirk Koopman
> Sent: 11 February 2005 11:54 AM
> To: FreeTDS Development Group
> Subject: Re: [freetds] insert varchar/text fields limited to
> max 80 characters
>
> 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 mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>





Archive powered by MHonArc 2.6.24.

Top of Page