note 88422 added to function.mssql-query
| From: | matcad7130 at yahoo dot com | Date: | Fri, 23 Jan 2009 13:00:11 +0000 |
| Subject: | note 88422 added to function.mssql-query | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-149687@lists.php.net to get a copy of this message | ||
I have an Ubuntu 8.10 (Linux 2.6.27-7-server #1) with PHP Version 5.2.6-2ubuntu4
When I am trying to fetch values from a MsSQL 2005 decimal(18,0) data type, I get my result rounded
with 3 digits to the left.
My workaround was to cast for varchar.
For example:
SELECT DISTINCT CAST(oid AS VARCHAR(15)), oid FROM mytable;
return the following set of data:
281478106317000 ------ 281478106316919
281478106317000 ------ 281478106316920
281478106317000 ------ 281478106316921
281478106317000 ------ 281478106316922
The application was ported from a Fedora box, where we didn't encounter this behavior.
Does anybody find other solution? (settings related)
----
Server IP: 69.147.83.197
Probable Submitter: 193.230.195.1
----
Manual Page -- http://www.php.net/manual/en/function.mssql-query.php
Edit -- https://master.php.net/note/edit/88422
Del: integrated -- https://master.php.net/note/delete/88422/integrated
Del: useless -- https://master.php.net/note/delete/88422/useless
Del: bad code -- https://master.php.net/note/delete/88422/bad+code
Del: spam -- https://master.php.net/note/delete/88422/spam
Del: non-english -- https://master.php.net/note/delete/88422/non-english
Del: in docs -- https://master.php.net/note/delete/88422/in+docs
Del: other reasons-- https://master.php.net/note/delete/88422
Reject -- https://master.php.net/note/reject/88422
Search -- https://master.php.net/manage/user-notes.php