I have a mysql database with simple cms to insert update records. 1 of the fields you can update is the price of an article. The field is set to decimal(length 19 and decimals 2) in the database and I insert and update this field as numeric value in cms...
I apparently need the notation of the currency to be 24.95 in my cms to insert the data correctly in to database. If I use: 24,95 it only registers 24
However when displayed on the site or in the database itselve and the cms update page to, the entered value gets displayed like: 24,95 instead of the entered 24.95
A. I do not get why it does this
B. What besides a replacestring in the price field value on the update page of the cms to ensure it gets updated correctly (with . instead of ,) can i do to get the price displaid like I want and that is with .(dot) on the site...
I dont get it... Hope someone can help me understand this.
What confuses me is that I have to enter it like 24.95 to make sure it gets written in to database like 24,95