On Sat, Dec 28, 2002 at 11:06:32AM -0800, 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?
>
> perldoc DBI
Assuming this is the problem, it would be handy if DBD::ODBC followed
DBD::Oracle's lead and added a hint to the error message:
... (DBD: st_fetch/SQLFetch (long truncated, DBI attribute LongTruncOk not set
and/or LongReadLen too small) ...
Tim.
