Re: MS ACCESS text field truncated
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. Thanks, J. Tim Johnson [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] 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.
RE: MS ACCESS text field truncated
D'oh! You're right. I guess I should get more sleep before answering questions... -Original Message- From: Jason [mailto:[EMAIL PROTECTED] Sent: Thursday, March 04, 2004 2:16 PM To: [EMAIL PROTECTED] Subject: Re: MS ACCESS text field truncated 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. Thanks, J. Tim Johnson [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Look in the docs for the $dbh-LongTruncOk and $dbh-LongReadLen properties.
RE: MS ACCESS text field truncated
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.
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); 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.
RE: MS ACCESS text field truncated
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.