[Zope] Truncation Reading from ODBC

[Jerry Westrick]

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.