FreeTDS Development Group

["Marschner, Eric" <emarschner AT alpineaccess.com>]

I ran into this issue as well, and the only thing I could do to resolve it 
was make a code change in:

./src/tds/query.c

Change varchar(80) to varchar(max) on line 796 in the 
tds7_build_param_def_from_query function.  This did not fix the issue 
entirely, as I believe my values are being truncated to 8000 when I insert or 
update.  Ideally, there would be no truncation at all for varchar(max) (~2GB).

I am using the dev build freetds-0.83.dev.20090915 currently.

Eric


Eric Marschner
Sr. Software Engineer

--------------------------------------------------------------------------
Alpine Access |  http://www.alpineaccess.com
Phone: 720.559.4724 |  Mobile: 720.201.9468


Find Your Way Home™

This E-mail message is for the sole use of the intended recipient(s) and may 
contain confidential and privileged information. Any unauthorized review, 
use, disclosure or distribution is prohibited. If you are not the intended 
recipient, please contact the sender by reply E-mail and destroy all copies 
of the original message.


-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org 
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Alan Humphrey
Sent: Monday, November 23, 2009 12:22 PM
To: FreeTDS AT lists.ibiblio.org
Subject: [freetds] varchar column truncated on update

Hi all -

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.

There is a thread about this issue back in April but there is no resolution.
Is this a problem with a known solution?  If not, what can I do to help?
You don't want me digging around in the code, but I can provide log files
etc.

Many Thanks!

- Alan



_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds