I would suggest that the issue is with the ODBC driver. I had similar issues getting data out of a DB2 database and after fiddling around for hours with code found a checkbox on a tab for the driver (DSN). Hope that helps. -----Original Message----- From: J Cameron Cooper [mailto:jccooper@jcameroncooper.com] Sent: Saturday, 9 August 2003 7:08 AM To: Zope user list Subject: Re: [Zope] Truncation Reading from ODBC

I'm trying to read (and later probably write) large strings to a postgress database. ... When I read a column with 20,000+ characters I only get the first 8194 characters.

Is this: 1) a Zope restriction?

This is a very unlikely cause, but I recall that certain Python data structures (files?) may look like strings up to a certain point, but then contain a link to another node with more data. You can get the whole of the contents by str(the_thing). But them, you're probably using the string type already. --jcc -- "My point and period will be throughly wrought, Or well or ill, as this day's battle's fought." _______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )