#31702 [NEW]: strings returned with 'pg_fetch_result' are incomplete

From: kevin dot bray at utoronto dot ca Operating system: Mac OS X 10.3.7 PHP version: 5.0.3 PHP Bug Type: PostgreSQL related Bug description: strings returned with 'pg_fetch_result' are incomplete Description: ------------ When using pg_fetch_result to obtain field values (in this case, strings), PHP seems to print/echo only the first character in the value, I'm working with the following table (forgive the odd test values): arkhiv=# select * from docsender; doctitle | sender ------------------------------+---------- letter about cheese | bob letter about cheese | george note about peas | helen note about peas | god note about peas | bob Reproduce code: --------------- // pg_connect() code omitted above $result = pg_query("SELECT docSender.sender FROM docSender WHERE docSender.doctitle = 'letter about cheese'"); ?> <table> <? $loopCount=0; $rowCount = pg_num_rows($result); while ($loopCount < $rowCount){ $send = pg_fetch_result($result, $loopCount, 0); ?> <tr> <td> <? print 'Author: ' . $send['sender']; ?> </td> <td> <? var_dump($send); ?> </td> </tr> <? $loopCount++; } //endwhile ?> </table> Expected result: ---------------- I expected to see this: -------------------------------------------- <html> <table> <tr> <td> Author: bob</td> <td> string(3) "bob" </td> </tr> <tr> <td> Author: george</td> <td> string(6) "george" </td> </tr> </table></body> </html> Actual result: -------------- Only the initial characters (ie, 'b' and 'g') of 'bob' and 'george' appeared in the first <td> fields: --------------------------------------------- <html> <table> <tr> <td> Author: b </td> <td> string(3) "bob" </td> </tr> <tr> <td> Author: g </td> <td> string(6) "george" </td> </tr> </table></body> </html> --------------------------------------------- I inserted "var_dump();" to check if postgres was returning the entire value of the field. Apparently it is, so the shortened string must result from a later (ie PHP) problem. Thank you for your attention. -- Edit bug report at http://bugs.php.net/?id=31702&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=31702&r=trysnapshot4 Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=31702&r=trysnapshot50 Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=31702&r=trysnapshot51 Fixed in CVS: http://bugs.php.net/fix.php?id=31702&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=31702&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=31702&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=31702&r=needscript Try newer version: http://bugs.php.net/fix.php?id=31702&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=31702&r=support Expected behavior: http://bugs.php.net/fix.php?id=31702&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=31702&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=31702&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=31702&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=31702&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=31702&r=dst IIS Stability: http://bugs.php.net/fix.php?id=31702&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=31702&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=31702&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=31702&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=31702&r=mysqlcfg