ID: 33005
Updated by: [EMAIL PROTECTED]
Reported By: dan at yes dot lt
-Status: Open
+Status: Feedback
Bug Type: MySQLi related
Operating System: winxp
PHP Version: 5CVS-2005-05-11 (dev)
New Comment:
Can't reproduce
Connecting to MySQL 4.1 returns
int(1)
float(1.23)
Connectiong to MySQL 5.0 returns
int(1)
string(4) "1.23"
Which MySQL client library and server do you use?
Previous Comments:
------------------------------------------------------------------------
[2005-05-11 07:58:39] dan at yes dot lt
Description:
------------
mysqli do not supports float type neither in results nor in params. for
result it returns NULL instead of float, for params there is no type
letter for float type...
Reproduce code:
---------------
$db = new mysqli(...);
$st = $db->prepare("SELECT 1.23 AS test");
$st->execute();
$st->store_result();
var_dump($st->num_rows);
$st->bind_result($x);
$st->fetch();
$st->free_result();
$st->close();
var_dump($x);
Expected result:
----------------
int(1)
float(1.23)
Actual result:
--------------
int(1)
NULL
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=33005&edit=1