Re: 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.

holli, /regexed monk/

Comment on Re: Accessing MS-Access memofield via DBI Download Code

Replies are listed 'Best First'.
Re^2: Accessing MS-Access memofield via DBI by reneeb (Chaplain) on Sep 12, 2005 at 12:47 UTC
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)` [download] 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...	[reply] [d/l]
Re^2: Accessing MS-Access memofield via DBI by Anonymous Monk on Sep 12, 2005 at 12:45 UTC
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.	[reply]