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
View Add Comment Developer Edit
Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know!
Just going to say 'Me too!'? Don't clutter the database with that please !
Your email address:
MUST BE VALID
Solve the problem:
49 - 15 = ?
Subscribe to this entry?

 
 [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

Add a Patch

Pull Requests

Add a Pull Request

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: Thu Apr 18 19:01:30 2024 UTC