Re: Accessing MS-Access memofield via DBI

[holli]

in reply to Accessing MS-Access memofield via DBI

255 is the max length of a string field. Are you sure you really have a memo field?

Also you might give the DBD::ADO module a try. No need to use ODBC when a "native" driver is available.

[Anonymous Monk]

Yes, I'm sure that I have a memofield. And dumping the table (extract info with DBI), I get the following information:
<code> columnname: description datatype: LONGCHAR(1073741823) <code>

And to ensure that I use the right datatype, I had a look at the table - it is memo.

[reneeb]

Yes, I'm sure that I have a memofield. And dumping the table (extract info with DBI), I get the following information:


columnname: description 
datatype: LONGCHAR(1073741823) 


And to ensure that I use the right datatype, I had a look at the table - it is memo. I will give DBD::ADO a try...