Re: varchar column truncated on update
Frediano Ziglio <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
2009/11/24 James K. Lowden <[email protected]>: > 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. > I think dynamic in ctlib will use parameterized TDS 7.0+. ODBC prepare again if size is greater than previous prepare. varchar(max) is supported by 7.2 which is still not enabled by default (for very good reasons!) so server will use greatest varchar (which is varchar(8000)). freddy77 _______________________________________________ FreeTDS mailing list [email protected] http://lists.ibiblio.org/mailman/listinfo/freetds