|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2015-12-03 14:32 UTC] mariuz@php.net
-Assigned To:
+Assigned To: mariuz
[2015-12-03 14:33 UTC] mariuz@php.net
-Status: Assigned
+Status: Duplicate
[2015-12-03 14:33 UTC] mariuz@php.net
|
|||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Fri Oct 24 10:00:01 2025 UTC |
Description: ------------ Dear List! i have a strange problem. I have a Firebird database (dialect 3). Firebird server: 2.0.6 I create a table, and insert a row like that: CREATE TABLE PRICE ( ID INTEGER NOT NULL, "NAME" VARCHAR(10), COST NUMERIC(15, 2)); INSERT INTO PRICE (ID, "NAME", COST) VALUES (2, 'my price2', -1); when i read it back i get strange value. I get -0.0 and not -1. Thanks for your advice, Paul Test script: --------------- $db=new PDO("firebird:dbname=localhost:c:/test/test.fdb","testuser","testpassword",array()); $sql="select cost from price where id=2"; $q=$db->query($sql); $ret=$q->fetchAll(PDO::FETCH_ASSOC); print_r($ret); result: Array ( [0] => Array ( [COST] => -0.00 ) ) Expected result: ---------------- -1.00 Actual result: -------------- -0.00