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

ID: 22623 Updated by: sniper@php.net Reported By: tolochanov at elit dot lviv dot net -Status: Open +Status: Feedback Bug Type: MSSQL related Operating System: Windows 2000 Professional SP3 PHP Version: 4.3.1 New Comment: 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 Previous Comments: ------------------------------------------------------------------------ [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