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

ID: 33005 Updated by: andrey@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) -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] 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