Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW
 
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/


Comment on Re: Accessing MS-Access memofield via DBI
Download Code
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.
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...

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 chanting in the Monastery: (7)
As of 2014-12-18 02:57 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    Is guessing a good strategy for surviving in the IT business?





    Results (41 votes), past polls