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

Reply via email to