dbi and sqlserver truncating text

fionbarr has asked for the wisdom of the Perl Monks concerning the following question:

I'm using DBI with Perl to write to MSSQLserver tables. I am trying to write a string string to a TEXT defined column and it is always being truncated to 80 chars. Is there any remedy for this?

Comment on dbi and sqlserver truncating text

Replies are listed 'Best First'.
Re: dbi and sqlserver truncating text by marto (Cardinal) on Mar 23, 2012 at 15:57 UTC
Are you using freeTDS? The reason I ask is freetds silently truncating text/varchar/etc fields to 80 characters.	[reply]
Re^2: dbi and sqlserver truncating text by fionbarr (Friar) on Mar 23, 2012 at 16:10 UTC
yes....thanks for the response...I'm using placeholders...I'm going to use a SQL string.	[reply]
Re^3: dbi and sqlserver truncating text by Anonymous Monk on Mar 23, 2012 at 16:12 UTC
If you read all of that thread there was a fix for it.	[reply]
Re^4: dbi and sqlserver truncating text by Anonymous Monk on Mar 23, 2012 at 17:11 UTC