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: 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 13:54:15 +0000

On Fri, 2005-02-11 at 14:34 +0200, Piet De Jong wrote:
> 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.

Well it does not seem to work for me. I am now doing the same thing. I
set the blocksize up to 1024 as well. Still only 80 characters written
for large varchars or text fields. I am now starting to suspect MSSQL
2003 itself. I wonder if it has another parameter to tweak.

Dirk





Archive powered by MHonArc 2.6.24.

Top of Page