<?xml version="1.0" encoding="windows-1252"?>
<node id="767154" title="DBD_ODBC 1.21 does not accept DBI::SQL_LONGVARCHAR as data type anymore?" created="2009-05-31 21:31:43" updated="2009-05-31 21:31:43">
<type id="115">
perlquestion</type>
<author id="710213">
taioba</author>
<data>
<field name="doctext">
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:&lt;p&gt;

[http://www.perlmonks.org/?node=Cannot%20insert%20into%20MS%20Access%20Memo%20field%20with%20DBI]&lt;p&gt;

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:&lt;p&gt;


DBD::ODBC::st bind_param failed: Microsoft ODBC Microsoft Access Driver Invalid precision value  (SQL-HY104)&lt;p&gt;

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?&lt;p&gt;

Thanks for your ever wise and kind guidance.</field>
</data>
</node>
