ID: 33005
User updated by: dan at yes dot lt
Reported By: dan at yes dot lt
-Status: Feedback
+Status: Open
Bug Type: MySQLi related
Operating System: winxp
PHP Version: 5CVS-2005-05-11 (dev)
New Comment:
PHP Version 5.0.5-dev
MySQLi Client API version 4.1.7
MySQL Server version: 5.0.4-beta
Previous Comments:
------------------------------------------------------------------------
[2005-05-11 09:36:37] [EMAIL PROTECTED]
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?
------------------------------------------------------------------------
[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
