Stefan... Muchachas Graciosas! Um, yes the 20000+ characters are really in the database (as seen with PGADMIN II) and confirmed with "select length(contents) from files" hmmm, but I'm glad to hear all the no's, maybe I'll find a work around then... Back to inserting debug print statements.... On Fri, 2003-08-08 at 10:02, Stefan Drees wrote:
On Fri, Aug 08, 2003 at 04:04:14AM +0200 - a wonderful day - Jerry Westrick wrote:
I'm trying to read (and later probably write) large strings to a postgress database.
I'm using the egenix ODBC adapter, and the unix ODBC postgress driver.
When I read a column with 20,000+ characters I only get the first 8194 characters.
Is this: 1) a Zope restriction? No. No I guess not (see below first)
2) a UnixOdbc restriction? No. I guess not (see below first)
3) a egenix ODBC restriction? No. I guess not (see below first)
4) an ODBC protocol restiction? No. I guess not (see below first)
What about PostgreSQL. Which Version? A short glimpse at the online postgresql manual - namely at http://www.postgresql.org/docs/7.2/static/datatype-character.html yields: """Note: Prior to PostgreSQL 7.2, strings that were too long were silently truncated, no error was raised. """ Ok, looking at the online docs of one of those prior versions is left as an exercise to the poster. But since such a few kilobyte limit isn't exactly what everyone likes, I wouldn't be to surprised, if the exact amount is nurried somwewhere ...
Are those 20000+ characters really in the database? Hint: psql is a friend.
All the best, Stefan Drees.