#16383 [Com]: mysql_fetch_assoc returns strings only

ID: 16383 Comment by: yextir at gmx dot at Reported By: suraev at tut dot by Status: Bogus Bug Type: MySQL related Operating System: Win2000 PHP Version: 4.1.1 New Comment: It would be great if the following would be added to the manual: mysql_fetch_assoc returns strings only. I thought it's a bug too. But you are right, it doesn't matter if you know why it returns a string. cu daBart Previous Comments: ------------------------------------------------------------------------ [2002-04-02 18:45:50] yohgaki@php.net PostgreSQL module is the same. All user inputs ($_POST,$_GET,etc) are string. This design is good. For example, PHP does not support large number, but DB supports very large number. If PHP convert numbers automatically, PHP cannot display db query result correctly. ------------------------------------------------------------------------ [2002-04-02 15:02:12] derick@php.net a. MySQL returns only strings with the C api call b. PHP is typeless c. it has been ages like this d. In order to 'fix' this, we need to call atleast 4 new api calls, thus slowing down queries a LOT This change is not going to happen. Derick ------------------------------------------------------------------------ [2002-04-02 14:47:55] suraev at tut dot by Why you decide that it's a support question? No, you are not right. It's not important for me, as I found a way to make my scripts work fine even with this error. But I still think that php development team should know that their function doesn't work the way it has to. If function has to return an array with integer value, but returns an array with string value - it's a bug. That's why I wrote here. Sincerely, Val suraev@tut.by ------------------------------------------------------------------------ [2002-04-01 16:39:44] derick@php.net The bug system is not the appropriate forum for asking support questions. For a list of a range of more appropriate places to ask for help using PHP, please visit http://www.php.net/support.php ------------------------------------------------------------------------ [2002-04-01 16:30:05] suraev at tut dot by Hello, I found a strange behaviour while was working with mysql_fetch_array and mysql_fetch_assoc. Even if table has an integer field, the result I got from functions listed above will list this value as string. php.ini magic_quotes_runtime = Off simple example. imagine that we "create table tripreport (ID tinyint)" then we "insert into MYTABLE (ID) values (1)" then $r="select * from MYTABLE where ID=1" then $f=mysql_fetch_assoc($r); then $id=$f["ID"]; then echo gettype($id) will print "string". is it an internal MySQL bug of PHP makes a mistake? take care, Val ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=16383&edit=1