* 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]
; <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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
Hello.
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 quess the reason fo