[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