#30687 [NEW]: Second read attempt on memo (LONGCHAR) fields via ODBC fails

From: albin at kth dot se Operating system: Windows XP Pro SP2 PHP version: 5CVS-2004-11-04 (dev) PHP Bug Type: ODBC related Bug description: Second read attempt on memo (LONGCHAR) fields via ODBC fails Description: ------------ There seems to be a problem reading Memo-fields (ODBC-type LONGCHAR) from an MS-Access database via ODBC... The first attempt is successfull, but if you try to read the same field again from the same result-set you get nothing. Reading non-memo-fields multiple times works OK. Reproduce code: --------------- $db = odbc_connect('DATABASE','XXXX','XXXX'); $res = odbc_exec($db, "SELECT Body FROM Letters WHERE LetterID = X"); echo "First attempt: ".odbc_result($res, 'Body'); // displays the letter body echo "Second attempt: ".odbc_result($res,'Body'); // displays nothing Expected result: ---------------- First attempt: [Letter body] Second attempt: [Letter body] Actual result: -------------- First attempt: [Letter body] Second attempt: -- Edit bug report at http://bugs.php.net/?id=30687&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=30687&r=trysnapshot4 Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=30687&r=trysnapshot50 Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=30687&r=trysnapshot51 Fixed in CVS: http://bugs.php.net/fix.php?id=30687&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=30687&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=30687&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=30687&r=needscript Try newer version: http://bugs.php.net/fix.php?id=30687&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=30687&r=support Expected behavior: http://bugs.php.net/fix.php?id=30687&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=30687&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=30687&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=30687&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=30687&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=30687&r=dst IIS Stability: http://bugs.php.net/fix.php?id=30687&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=30687&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=30687&r=float MySQL Configuration Error: http://bugs.php.net/fix.php?id=30687&r=mysqlcfg