[PHP-DEV] Bug #1112: Error retrieving numeric/decimal data From: martin <email protected>
Date: 02/02/99

From: martin <email protected>
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 <email protected>
For help: php-dev-help <email protected>