http://www.perlmonks.org?node_id=782408


in reply to Re^2: Cannot insert into MS Access Memo field with DBI
in thread Cannot insert into MS Access Memo field with DBI

This sounds crazy but I had this problem trying to put a string into the ms access memo field and after pulling out my hair I got the data in by putting it in an array. edit: array is NOT NEEDED. just do the blob support i.e.:

$dbh->{LongReadLen} = 20000; #(change 20000 to your needs)
$dbh->{LongTruncOk}=1; #(truncate at 20000)

***update: the blob support fixes it for going in too so the array is not needed. you can put the big string in if LongReadLen is active. d'oh.