#19588 [Opn->Fbk]: Problems with smallmoney datatype

ID: 19588 Updated by: iliaa@php.net Reported By: falk at surrounded dot de -Status: Open +Status: Feedback Bug Type: MSSQL related Operating System: Windows XP Pro PHP Version: 4.2.3 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-02-21 11:09:20] jayc_lawrence at hotmail dot com I have had problems with mssql 7.0 and the decimal function. I have changed the scale and precision numerous times to find that the value does not change number of decimal places... however when i executed a similar query on an mssql 2000 box i found that the decimal function worked exactly as documented. Im not sure whether its an issue with mssql 7 or whether my db is botched.. however to me it appears this may be a mssql server side rather than a PHP issue.. Oh and you mention you are using msde.. why dont you try the same query in query analyser and see if it fails too? Im aware you dont get enterprise manager with it, but if you have a mssql server licence you can use the enterprise manager from that for it i believe. ------------------------------------------------------------------------ [2002-12-23 04:07:06] falk at surrounded dot de The mentioned release behaved unfortunately exactly the same, but the transferred data amount could be increased. ------------------------------------------------------------------------ [2002-12-23 01:00:04] php-bugs at lists dot php dot net No feedback was provided for this bug for over 2 weeks, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open". ------------------------------------------------------------------------ [2002-12-07 01:38:38] iliaa@php.net Please try using this CVS snapshot: http://snaps.php.net/php4-latest.tar.gz For Windows: http://snaps.php.net/win32/php4-win32-latest.zip ------------------------------------------------------------------------ [2002-09-25 04:37:25] falk at surrounded dot de Information as of phpinfo(): PHP Version 4.2.3 System Windows NT 5.1 build 2600 Build Date Sep 6 2002 10:38:51 Server API CGI Debug Build no Thread Safety enabled mssql MSSQL Support enabled Library version 7.0 Directive Local Value Master Value mssql.allow_persistent On On mssql.batchsize 0 0 mssql.compatability_mode Off Off mssql.connect_timeout 5 5 mssql.datetimeconvert On On mssql.max_links Unlimited Unlimited mssql.max_persistent 10 10 mssql.min_error_severity 10 10 mssql.min_message_severity 10 10 mssql.textlimit Server default Server default mssql.textsize Server default Server default mssql.timeout 60 60 Zend Optimizer installed _ENV["SERVER_SOFTWARE"] Microsoft-IIS/5.1 _ENV["PROCESSOR_IDENTIFIER"] x86 Family 6 Model 4 Stepping 2, AuthenticAMD Running with MS SQL 7.0 Desktop Edition (I don't know whether this appears with MS SQL 2000). ****** Report: When selecting more than a small amount of rows (approx. 10) using mssql_query from a table including a smallmoney column, the script will immediately abort execution. This problem does not appear when using decimal(9,2) columns instead of smallmoney. Thus, a possible workaround for me was to CAST the smallmoney-column to decimal ("SELECT CAST ( value decimal(9,2))" instead of "SELECT value"). TIA for your time, best wishes, Falk ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=19588&edit=1