FreeTDS Development Group

[Dirk Koopman <freetds AT tobit.co.uk>]

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