#39643 [NEW]: Integers selected from a MySQL-database are treated as strings

From: harmen_php_net at xtremesf dot nl Operating system: PHP version: 5.2.0 PHP Bug Type: MySQLi related Bug description: Integers selected from a MySQL-database are treated as strings Description: ------------ When executing the query below, I get the wrong result. Although the database returns a integer, PHP treats it as a string. Here the relevant part of phpinfo(): MysqlI Support enabled Client API library version 5.0.27 Client API header version 5.0.27 MYSQLI_SOCKET /tmp/mysql.sock The version of the MySQL server is 5.0.27 Reproduce code: --------------- <pre> <?php $rDB = mysqli_connect('localhost', 'user', 'password', 'db'); mysqli_select_db($rDB, 'db'); $rResult = mysqli_query($rDB, 'SELECT id FROM producten WHERE id = 4472'); var_dump(mysqli_fetch_array($rResult)); echo "\n---\n"; var_dump(mysqli_fetch_field($rResult)); ?> </pre> Expected result: ---------------- array(2) { [0]=> int(4) "4472" ["id"]=> int(4) "4472" } --- object(stdClass)#3 (11) { ["name"]=> string(2) "id" ["orgname"]=> string(2) "id" ["table"]=> string(9) "producten" ["orgtable"]=> string(9) "producten" ["def"]=> string(0) "" ["max_length"]=> int(4) ["length"]=> int(11) ["charsetnr"]=> int(63) ["flags"]=> int(49699) ["type"]=> int(3) ["decimals"]=> int(0) } Actual result: -------------- array(2) { [0]=> string(4) "4472" ["id"]=> string(4) "4472" } --- object(stdClass)#3 (11) { ["name"]=> string(2) "id" ["orgname"]=> string(2) "id" ["table"]=> string(9) "producten" ["orgtable"]=> string(9) "producten" ["def"]=> string(0) "" ["max_length"]=> int(4) ["length"]=> int(11) ["charsetnr"]=> int(63) ["flags"]=> int(49699) ["type"]=> int(3) ["decimals"]=> int(0) } -- Edit bug report at http://bugs.php.net/?id=39643&edit=1 -- Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=39643&r=trysnapshot44 Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=39643&r=trysnapshot52 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=39643&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=39643&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=39643&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=39643&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=39643&r=needscript Try newer version: http://bugs.php.net/fix.php?id=39643&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=39643&r=support Expected behavior: http://bugs.php.net/fix.php?id=39643&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=39643&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=39643&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=39643&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=39643&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=39643&r=dst IIS Stability: http://bugs.php.net/fix.php?id=39643&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=39643&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=39643&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=39643&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=39643&r=mysqlcfg