php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #1112 Error retrieving numeric/decimal data
Submitted: 1999-02-02 03:49 UTC Modified: 1999-11-05 03:56 UTC
From: martin at pinknet dot cz Assigned:
Status: Closed Package: Sybase (dblib) related
PHP Version: 3.0.6 OS: RedHat, 2.0.35
Private report: No CVE-ID: None
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: martin at pinknet dot cz
New email:
PHP Version: OS:

 

 [1999-02-02 03:49 UTC] martin at pinknet dot cz
<? $test=sybase_query("SELECT * from pokus");
$data=sybase_fetch_array($test);
echo "$data[name] ... $data[cost]");
?>
The pokus table created using:
CREATE TABLE pokus (
name char(8),
cost numeric(5,2)
)
INSERT INTO pokus VALUES ("TheName",43.72);
The data returned contains eg. 43.7199999999, and in worse case 43.719999999f#gke or other letters, obviously from the PHP memory (bad/no allocation?)
Sometimes it works as expected - the returned value 43.72. So give it a time, recreate the table, or somewhat that.
I also experienced problem, that the returned columns has too much \0, so it stops the output to netsape. And please, the image data can be retrieved and/or decoded in some good manner? They are at first too short(not enough bytes) and I'd also appreciate the function to decode it directli to raw data.
A think, that the configuration is not neccessary.
Thank you for solving this annoying bugs. Martin Krupicka

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [1999-11-05 03:56 UTC] thies at cvs dot php dot net
fixed inCVS	
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Sat Dec 21 16:01:28 2024 UTC