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