Negative double not stored correctly

[Richard van Denzel]

Hi All,

I've defined a table (m) with an double field (bedrag) in it and when
I execute the next statement:

INSERT INTO m (bedrag) VALUES('-7000,00');

the value get stored correctly.

I've written a PHP-script which does the following:

$SQL="INSERT INTO m (getal) VALUES('$bedrag ')";
$res=mysql_quer y($SQL);
echo "SQL = ".$SQL."<br >";

When I look at the display from the echo statement it looks like:

SQL = INSERT INTO m (getal) VALUES('-7.000,00')

So that looks OK. But when I do a SELECT * FROM m; in MySQL the stored
value is -7,00 instead of -7000,00. I've defined the bedrag field as
DOUBLE(10,2) so that should not be a problem.
I'm using PHP 4.3.2 and MySQL 4.0.20a.

Can anyone tell me what I'm doing wrong here?

Richard.

[steve]

"Richard van Denzel" wrote:

Hi All,

I’ve defined a table (m) with an double field (bedrag) in it and
when
I execute the next statement:

INSERT INTO m (bedrag) VALUES(’-7000,00’);

the value get stored correctly.

I’ve written a PHP-script which does the following:

$SQL="INSERT INTO m (getal) VALUES(’$bedrag ’)";
$res=mysql_quer y($SQL);
echo "SQL = ".$SQL."<br >";

When I look at the display from the echo statement it looks like:

SQL = INSERT INTO m (getal) VALUES(’-7.000,00’)

So that looks OK. But when I do a SELECT * FROM m; in MySQL the stored value is -7,00 instead of -7000,00. I’ve defined the bedrag
field as
DOUBLE(10,2) so that should not be a problem.
I’m using PHP 4.3.2 and MySQL 4.0.20a.

Can anyone tell me what I’m doing wrong here?

Richard.

What’s "," in 7.000,00. Can you try removing the "," and see
what happens?

--
http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com/mySQL-Negati...ict136793.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=457416

[Bill Karwin]

Richard van Denzel wrote:

I've defined a table (m) with an double field (bedrag) in it and when
I execute the next statement:

INSERT INTO m (bedrag) VALUES('-7000,00');

As far as I can tell from the documentation, MySQL does not support the
German-style numeric format. You must use "." as the decimal point, and
no thousands separator is supported.

Perhaps one could write a UDF to parse strings in the German numeric
format, and convert them to decimal values before inserting them.
I don't know how to do this, but I imagine it would be possible.

Regards,
Bill K.