freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
Re: [freetds] freetds silently truncating text/varchar/etc fields to 80 characters
- 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
-
[freetds] freetds silently truncating text/varchar/etc fields to 80 characters,
Robert Jay, 04/22/2009
-
Re: [freetds] freetds silently truncating text/varchar/etc fields to 80 characters,
James K. Lowden, 04/22/2009
- Re: [freetds] freetds silently truncating text/varchar/etc fields to 80 characters, James K. Lowden, 04/22/2009
- <Possible follow-up(s)>
- [freetds] freetds silently truncating text/varchar/etc fields to 80 characters, Robert Jay, 04/23/2009
-
Re: [freetds] freetds silently truncating text/varchar/etc fields to 80 characters,
James K. Lowden, 04/22/2009
Archive powered by MHonArc 2.6.24.