Skip to Content.
Sympa Menu

freetds - Re: [freetds] varchar column truncated on update

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "James K. Lowden" <jklowden AT freetds.org>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] varchar column truncated on update
  • Date: Tue, 24 Nov 2009 00:07:49 -0500

Alan Humphrey wrote:
>
> I have a varchar(4000) column in a SQL Server 2005 database. When I try
> to update the column via DBD::Sybase it is truncated at 80 characters.

We know ct-lib, which is what DBD::Sybase uses, handles character columns
larger than 80 characters (cf. sqsh).

Post a TDSDUMP log of your session. It can also help if your route both
TDSDUMP and DBI trace to stderr, and redirect stderr to a file, so that
DBI and freetds logging are interspersed.

I doubt Eric Marschner's reply fits your case because you're using
DBD::Sybase. The routine he modified supports parameterized TDS 7.0+
queries, which aren't supported by ct-lib.

--jkl




Archive powered by MHonArc 2.6.24.

Top of Page