try to use "replace" function:
update YourTable set YourMoney = REPLACE('255,55', ',', '.') where ... ;
----- Original Message -----
From: "Asbjørn Konstad" <asbjorn@stripped>
Sent: Monday, January 12, 2004 11:33 AM
Subject: Storing currency values
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??
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