note 88422 rejected from function.mssql-query by danbrown
| From: | danbrown@php.net | Date: | Fri, 23 Jan 2009 16:04:14 +0000 |
| Subject: | note 88422 rejected from function.mssql-query by danbrown | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-149695@lists.php.net to get a copy of this message | ||
Note Submitter: matcad7130 at yahoo dot com
----
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)