in reply to Accessing MS-Access memofield via DBI

Hi,

You need to set DBIs LongReadLen() attribute.
Have a read a the the documentation.
Try something like:
!/usr/bin/perl
use strict;
use warnings;
use DBI;

my $dbh = DBI->connect('DBI:ODBC:driver=Microsoft Access-Treiber (*.md
+b);dbq=db1.mdb',user,pass);
$dbh->{'LongReadLen'} = 6000; # For have a maximum of 6000 chars...
#... and so on....

[download]

Hope this helps,

Martin

Replies are listed 'Best First'.
Re^2: Accessing MS-Access memofield via DBI
by Anonymous Monk on Sep 12, 2005 at 12:34 UTC
    The LongReadLen attribute is not for inserting values (from documentation: The LongReadLen attribute only relates to fetching and reading long values; it is not involved in inserting or updating them.)
[reply]
[d/l]
      Ack,

      Thanks for pointing out my brain burp of the day.
      InfiniteSilence and holli have both replied to the OPs first post with solutions.

      Martin
[reply]

In Section Seekers of Perl Wisdom