PHP is chopping off my Access Memo Fields

Published on July 30, 2008, 10:29 a.m.

I've got a few simple web forms that use PHP to read and write to an Access database (running on IIS), and I just spent the last few hours frantically trying to figure out why some of my Memo fields were being truncated around 4000 characters.

I know Memo fields "should" be able to contain up to 65536 characters, and I could verify this by inserting data directly into the database. However, when querying the database through PHP (using odbc), I could only retrieve 4000 characters.

The culprit? A tiny little setting called odbc.defaultlrl! (lrl = long read length). This can be changed in php.ini, or you can use ini_set to modify this setting directly in your php script:
<?php
ini_set('odbc.defaultlrl', 65536);
?>

I found this info on the discussion for the odbc_longreadlen function.
comments powered by Disqus