Bug #1112: Error retrieving numeric/decimal data

From: 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

« previous php.dev (#3840) next »