[freetds] insert varchar/text fields limited to max 80 characters
Piet De Jong
piet at ahead-tech.net
Fri Feb 11 07:34:38 EST 2005
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
>
More information about the FreeTDS
mailing list