* Asbjørn Konstad
> Ive 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 qu
Just convert the format of the input in your program before saving the value. In
VB/ASP us can do: replace(255,55,",",".")
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: M
