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

ID: 22623 User updated by: tolochanov at elit dot lviv dot net Reported By: tolochanov at elit dot lviv dot net Status: Closed Bug Type: MSSQL related Operating System: Windows 2000 Professional SP3 PHP Version: 4.3.1 New Comment: Thanks Previous Comments: ------------------------------------------------------------------------ [2003-05-20 18:47:21] fmk@php.net This has been fixed in cvs. I have just verified it with the latest CVS and it works on both Linux and Win32. ------------------------------------------------------------------------ [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