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)
-Assigned To:
+Assigned To: andrey
New Comment:
Cannot reproduce with PHP 5.1-dev, libmysql 4.1.12 and MySQL
5.0.6-beta.
Can you try upgrading your client library? Thanks!
Previous Comments:
------------------------------------------------------------------------
[2005-05-11 10:52:52] dan at yes dot lt
PHP Version 5.0.5-dev
MySQLi Client API version 4.1.7
MySQL Server version: 5.0.4-beta
------------------------------------------------------------------------
[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
