> -----Original Message-----
> From: Jason [mailto:[EMAIL PROTECTED]
> Sent: Friday, March 05, 2004 11:38 AM
> To: [EMAIL PROTECTED]
> Subject: Re: MS ACCESS text field truncated
>
>
> Hello Jeff,
>
> At first, I did put type longvarchar, then I read the doc and
> copy the type "LONGVARCHAR" to my code. All the other parts
> very simple because I use the default way to make connection
> and create prepared statement. The field $address is mapped
> to "Text" field of size 255 in MS ACCESS DB, but got
> truncated to "50", which is the default field size in MS ACCESS
>
> $iSth->bind_param(1, $name);
> $iSth->bind_param(2, $address, DBI::SQL_LONGVARCHAR);
It should work like this. I'd like versions on the following:
Access?
DBI?
DBD::ODBC?
Acess ODBC driver?
Also, if you set the DBI trace level to 9 and send me the trace, I will look
at it. If you are *not* using DBD::ODBC 1.07, then please upgrade to that
version before sending me the trace. (my trace settings were sadly broken
in versions prior to 1.06 or 1.07)
Regards,
Jeff
>
> Let me know if there is anything else you want. Thank you for
> your help.
>
> J.
>
>
>
> "Jeff Urlwin" <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED]
> > >
> > > Hi Tim,
> > >
> > > The doc says LongTruncOK and LongReadLen have nothing to do with
> > > writing data into DB. They are only for reading. In
> addition, I am
> > > dealing with "Text" type data in MS ACCESS, not "LONG" type.
> >
> > Just to butt in here...you should have specified that
> better in your
> > original posting.
> >
> > Please send your insert/update statement and snippet of
> code as to how
> > you are "logging" the data, so that we can help better.
> Most likely,
> > it's a problem with the binding. I may ask you to send a trace.
> >
> > Regards,
> >
> > Jeff
> >
> >
> > >
> > > Thanks,
> > > J.
> > >
> > > "Tim Johnson" <[EMAIL PROTECTED]> wrote in message
> > > news:78E0B682C9508740B37610A9342E9DCD034A90FE@>
> > > hqex1.sandisk.local...
> > >
> > > Look in the docs for the $dbh->LongTruncOk and $dbh->LongReadLen
> > > properties.
> > >
> > > -----Original Message-----
> > > From: Jason Q. [mailto:[EMAIL PROTECTED]
> > > Sent: Thursday, March 04, 2004 12:50 PM
> > > To: [EMAIL PROTECTED]
> > > Subject: MS ACCESS text field truncated
> > >
> > > Hi there,
> > >
> > > I am using DBI to access Microsoft ACCESS database. I
> found the data
> > > of "text" field logged by DBI has been truncated to 50
> characters. I
> > > have changed the field size from 50 to 255, but it still doesn't
> > > work. Anyone can help?
> > >
> > > Thanks,
> > > J.
> > >
> > >
> >
>
>
