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
 

Reply via email to