(sorry Michael, I meant to send this to the list)
--- Begin Message ---
Michael A Chase wrote:
> 
> On Sat, 28 Dec 2002 14:01:28 -0500 Jeff Thies <[EMAIL PROTECTED]> wrote:
> 
> >   I'm getting this error when I try to retrieve a field that is a text
> > field (memo, blob, or whatever Access calls it).
> >
> >  (1: [Microsoft][ODBC Microsoft Access Driver]String data, right
> > truncated on column number 1 (touravi)
> > (SQL-01004)(DBD: st_fetch/SQLFetch (long truncated) err=1))
> 
> How big are the contents of that column in that row and what are
> $dbh->{LongReadLen} and $dbh->{LongTruncOk} set to?

Errr. Not set at all!

Now set to:

$db->{LongReadLen}=255;
$db->{LongTruncOk}=1;

And it works! I've never set these in either MySQL or Postgress. Is this
something I should have been doing?

  Cheers,
(and many thanks to Michael, Jeff, Jeff and everyone else)
Jeff
--- End Message ---

Reply via email to