Edit report at http://bugs.php.net/bug.php?id=44341&edit=1
ID: 44341 Comment by: php_nospam at ramihyn dot sytes dot net Reported by: cortexd at wanadoo dot fr Summary: PDOStatement::fetch() always returning string values Status: Bogus Type: Bug Package: PDO related Operating System: Windows XP PHP Version: 5.2CVS-2008-03-05 (snap) Block user comment: N Private report: N New Comment: [quote] This only matters if the underlying driver tries to return native types. MySQL driver always returns strings. [/quote] 3 years later: its still bugged in PHP 5.3.6. Shouldnt that be fixed by compiling with mysqlnd? Previous Comments: ------------------------------------------------------------------------ [2008-03-09 17:26:40] il...@php.net Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://www.php.net/manual/ and the instructions on how to report a bug at http://bugs.php.net/how-to-report.php This only matters if the underlying driver tries to return native types. MySQL driver always returns strings. ------------------------------------------------------------------------ [2008-03-05 18:47:25] cortexd at wanadoo dot fr Description: ------------ PDOStatement::fetch() always returning string values, whatever the PDO::ATTR_STRINGIFY_FETCHES attribute value HTTP Server : Apache/2.2.6 (Win32) MySQL Server : 5.0.45-community-nt Reproduce code: --------------- <?php $mysql = new PDO('mysql:host=localhost;dbname=test', 'root', ''); $mysql->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, false); var_dump($mysql->query('SELECT 42')->fetch(PDO::FETCH_NUM)); ?> Expected result: ---------------- array(1) { [0]=> int(42) } Actual result: -------------- array(1) { [0]=> string(2) "42" } ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/bug.php?id=44341&edit=1
