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