[DB-SIG] mxODBC is truncating BLOBs when reading them

[M.-A. Lemburg]

Friedlander Paul wrote:
> I am using mxODBC to retrieve data from a Postgres database. I am using the
> latest ActivePython distribution.
> 
> When I read data from a column with BYTEA data I get a warning and am told
> that the data was truncated. I found a comment that this used to be a
> problem with MySQL databases but has been fixed.

Just guessing here since you don't provide enough information
(traceback, log file, versions, etc.): this could be related
to a network buffer problem or a problem with the ODBC driver
for Postgres. mxODBC doesn't truncate the data -- it's the
driver that's truncating it.

> I am using the Windows sub-object and am accessing the database through an
> ODBC converter provided by insight (running in the windows control panel).
> 
> Can anyone shed light on this?

Please post the traceback and give some hint about the size
of the data you are requesting.

Thanks,
-- 
Marc-Andre Lemburg
CEO eGenix.com Software GmbH
_______________________________________________________________________
eGenix.com -- Makers of the Python mx Extensions: mxDateTime,mxODBC,...
Python Consulting:                               http://www.egenix.com/
Python Software:                    http://www.egenix.com/files/python/