Clear questions and runnable code get the best and fastest answer |
|
PerlMonks |
comment on |
( [id://3333]=superdoc: print w/replies, xml ) | Need Help?? |
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.
|
|