#14397 [Com]: Wrong results when reading a float

ID: 14397 Comment by: kinkie@tiscalinet.it Reported By: hofmann@isl.org Status: No Feedback Bug Type: Sybase (dblib) related Operating System: Linux PHP Version: 4.0.6 New Comment: I have verified the same problem. In a table stored on a mssql 6.5 server, accessed via FreeTDS (both release 0.53 and 0.60.rc3) I have a column which is a float(24). I can confirm that accessing that table works fine both from the tsql utility supplied with freetds and from sqsh. That column's fields are however zeroed out when I access from inside PHP. This is both on 4.1.1 and 4.2.2. The host operating system is Redhat 7.1. Previous Comments: ------------------------------------------------------------------------ [2002-03-18 05:20:33] tony@ec-server.com I have the same error with PHP4.1.1. Even though I use float(16) instead of float(8), or use decimal(15,5), I got the wrong display when fetch a float/decimal/double field. ------------------------------------------------------------------------ [2002-01-28 10:41:54] sander@php.net No feedback. ------------------------------------------------------------------------ [2002-01-07 02:35:05] lobbin@php.net Can you reproduce this error with PHP 4.1.1? ------------------------------------------------------------------------ [2001-12-10 02:36:19] hofmann@isl.org I found that the wrong float results happen with float(8) but NOT with float(16) !!! ------------------------------------------------------------------------ [2001-12-10 02:05:59] hofmann@isl.org I have successfully written a float number into a sybase system - that I can display correctly with isql. But when reading with php I got back 0 oder some strange numbers as 6.784567 instead of teh correct float number. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=14397&edit=1