Re: varchar column truncated on update
"Marschner, Eric" <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <02578C028F4110448790B3E427492BF3445FAC9A91@a1exch01.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: [email protected] [mailto:[email protected]] On Behalf Of Alan Humphrey Sent: Monday, November 23, 2009 12:22 PM To: [email protected] 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 [email protected] http://lists.ibiblio.org/mailman/listinfo/freetds