Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked
 
PerlMonks  

Re: Accessing MS-Access memofield via DBI

by holli (Monsignor)
on Sep 12, 2005 at 12:36 UTC ( #491241=note: print w/ replies, xml ) Need Help??


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.


holli, /regexed monk/

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)

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

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://491241]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others exploiting the Monastery: (3)
As of 2016-08-25 01:31 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    The best thing I ever won in a lottery was:















    Results (352 votes). Check out past polls.