Bug #1112: Error retrieving numeric/decimal data
| From: | martin at pinknet dot cz | Date: | Tue, 02 Feb 1999 08:49:38 +0000 |
| Subject: | Bug #1112: Error retrieving numeric/decimal data | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-3840@lists.php.net to get a copy of this message | ||
From: martin@pinknet.cz
Operating system: RedHat, 2.0.35
PHP version: 3.0.6
PHP Bug Type: Sybase (dblib) related
Bug description: Error retrieving numeric/decimal data
<? $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
--
PHP Development Mailing List http://www.php.net/
To unsubscribe send an empty message to php-dev-unsubscribe@lists.php.net
For help: php-dev-help@lists.php.net