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

taioba has asked for the wisdom of the Perl Monks concerning the following question:

Hello, Monks. Like many I have struggled with trying to insert data in Access memo fields using DBI. Some of you have kindly explained how to do that in the posting below:

http://www.perlmonks.org/?node=Cannot%20insert%20into%20MS%20Access%20Memo%20field%20with%20DBI

I used to be able to insert info in memo fields in my Access database by binding the data using DBI::SQL_LONGVARCHAR. However, every since I upgraded DBD-ODBC to version 1.21, everytime I try to do that I get:

DBD::ODBC::st bind_param failed: Microsoft ODBC Microsoft Access Driver Invalid precision value (SQL-HY104)

If I use the column_info method to get the data type of the memo field, I get LONGCHAR instead of LONGVARCHAR. That does not work either, and I get the same message. Interesting enough, I do not have this problem if the data been inserted is smaller than 255 characters, even if it is a memo field. I also can insert data without a problem in INTEGER or VARCHAR fields. Any ideas?

Thanks for your ever wise and kind guidance.