Sunday, March 27, 2016

problem reading memo field

After a PHP upgrade from 5.3 to 5.5, one of our php applications reading data from an Access .mdb file had an issue - other fields were displaying fine, but the data from the memo field was showing blank.

After poking around for a couple of days, PB finally found the solution to be the one suggested in the comments at
https://bugs.php.net/bug.php?id=52658

That is, he had to add the optional cursor_type parameter SQL_CUR_USE_ODBC like
$cnx = odbc_connect('$databaseName', 'user', 'pass', SQL_CUR_USE_ODBC);

 Then it works. 

No comments:

Post a Comment