[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