Skip to Content.
Sympa Menu

freetds - Re: [freetds] freetds silently truncating text/varchar/etc fields to 80 characters

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] freetds silently truncating text/varchar/etc fields to 80 characters
  • Date: Wed, 22 Apr 2009 19:33:37 -0400

Robert Jay wrote:
> Using freetds v0.83.dev.20090421 (threadsafe, default tds version=5.0)
> connecting to a SQL2005 server i found that all of my text fields in
> INSERTs were being truncated to 80 characters.

Could you post a TDSDUMP log of a short session that illustrates the
problem? If you've found a bug, I'd like to see it fixed.

I don't see any relationship between what you describe and the code you're
pointing to, unless perhaps if you're using TDS 4.2. Otherwise
placeholders in Perl -- which is what tds7_build_param_def_from_query() is
for -- won't work because the ct-lib functionality requires server-side
support not provided by Microsoft servers.

With TDS 4.2, however paramaterized queries are strictly a client-side
string substitution. Not that many people use TDS 4.2, and maybe you've
found something.

--jkl






Archive powered by MHonArc 2.6.24.

Top of Page