#22623 [Opn->Csd]: In MSSQL 2000 Server real type is read as unknown type

From: Date: Tue, 20 May 2003 23:47:22 +0000
Subject: #22623 [Opn->Csd]: In MSSQL 2000 Server real type is read as unknown type
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-40102@lists.php.net to get a copy of this message 
 ID:               22623
 Updated by:       fmk@php.net
 Reported By:      tolochanov at elit dot lviv dot net
-Status:           Open
+Status:           Closed
 Bug Type:         MSSQL related
 Operating System: Windows 2000 Professional SP3
 PHP Version:      4.3.1
 New Comment:

This has been fixed in cvs. I have just verified it with the latest CVS
and it works on both Linux and Win32.


Previous Comments:
------------------------------------------------------------------------

[2003-03-12 04:36:21] tolochanov at elit dot lviv dot net

Latest Linux version works good.
Latest Windows version still don't read type 'real' correctly.

------------------------------------------------------------------------

[2003-03-10 09:22:23] sniper@php.net

Please try using this CVS snapshot:

  http://snaps.php.net/php4-STABLE-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php4-win32-STABLE-latest.zip



------------------------------------------------------------------------

[2003-03-10 07:59:29] tolochanov at elit dot lviv dot net

I used  mssql_fetch_row() function.

------------------------------------------------------------------------

[2003-03-10 07:54:49] tolochanov at elit dot lviv dot net

SQL 2000 Server on Win2000 Adv Server
Apache 2.0.43,PHP 4.3.1 on Win 2000 SP3

   While attempting to read field which contains data of 'real' type
(for ex. - 24,00 168,00 etc.), I get some sort of '1.36741241919E-304'
or other number near zero on every attempt. If I set that field to
SmallInt, the reading is OK.
   Function mssql_field_type() returns type 'unknown'.

------------------------------------------------------------------------


-- 
Edit this bug report at http://bugs.php.net/?id=22623&edit=1

Thread (8 messages)

« previous php.bugs (#40102) next »