Hi Asbjørn,
try to use "replace" function:
http://www.mysql.com/doc/en/String_functions.html
update YourTable set YourMoney = REPLACE('255,55', ',', '.') where ... ;
Best regards,
Mikhail.
----- Original Message -----
From: "Asbjørn Konstad" <asbjorn@stripped>
To: <mysql@stripped>
Sent: Monday, January 12, 2004 11:33 AM
Subject: Storing currency values
Hello.
I've spent some day(s) probing the web to find a solution to this problem:
A table-column for storing currency -> float(10,2).
As my users are punches the currency value like this "255,55", with a comma
as decimal point, MySQL stores this value as zero (0.00).
I quess the reason for this is that MySQL uses "." as decimal point for
float-types (or any decimal value).
Does anyone know of a workaround for this problem??. Is there any way of
changing the decimal separator in MySQL??
Reg.
A Konstad
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.558 / Virus Database: 350 - Release Date: 02.01.2004
