[freetds] insert varchar/text fields limited to max 80 characters
Dirk Koopman
freetds at tobit.co.uk
Fri Feb 11 08:54:15 EST 2005
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
More information about the FreeTDS
mailing list