troubleshooting Question

Curency formatting issue using dots and commas

Avatar of Witheet
WitheetFlag for Netherlands asked on
2 Comments1 Solution376 ViewsLast Modified:
Hello all,

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

Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 2 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros