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

ID: 33005 Updated by: georg@php.net 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