php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #58497 Money fields are returned without decimal separator
Submitted: 2009-01-09 07:36 UTC Modified: 2009-01-23 11:46 UTC
From: madeinlisboa at yahoo dot com Assigned:
Status: Closed Package: ingres (PECL)
PHP Version: 5.2.5 OS: WIndows XP SP3
Private report: No CVE-ID: None
View Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
If you reported this bug, you can edit this bug over here.
Block user comment
Status: Assign to:
Package:
Bug Type:
Summary:
From: madeinlisboa at yahoo dot com
New email:
PHP Version: OS:

 

 [2009-01-09 07:36 UTC] madeinlisboa at yahoo dot com 
Description:
------------
A money field is properly displayed ONLY if it is the first field on a query. Further money fields are shown without decimal separator.

Apache 2.2.8
PHP 5.2.6
php_ingres.dll 2.0.1
Ingres Database 9.3 v139

I even added to environment vars:
II_DECIMAL=.
II_MONEY_FORMAT=L:$
II_MONEY_PREC=2

and in Apache
PassEnv II_DECIMAL
PassEnv II_MONEY_PREC
PassEnv II_MONEY_FORMAT


Reproduce code:
---------------
#1
select
money_field1 as field1,
money_field1 as field2,
from table

#2
select
name as name1,
money_field1 as field1,
money_field2 as field2,
from table

Expected result:
----------------
#1
235.35 235.35
12.20 12.20
10.05 10.05

#2
james 235.35 235.35
andrew 12.20 12.20
john 10.05 10.05


Actual result:
--------------
#1
235.35 23535
12.20 1220
10.05 1005

#2
james 23535 23535
andrew 1220 1220
john 1005 1005

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2009-01-21 08:02 UTC] grant dot croker at ingres dot com 
I have an un-submitted fix awaiting verification.
 [2009-01-23 11:46 UTC] grant dot croker at ingres dot com 
Thank you for your bug report. This issue has been fixed
in the latest released version of the package, which you can download at
http://pecl.php.net/get/ingres
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved. 		Last updated: Fri Jan 03 03:01:29 2025 UTC