#33005 [Fbk->Opn]: mysqli do not support float type

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] georg@php.net 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