Thousand separator and decimal symbol problem
-
I am having a problem with an application running on a client's server. All my testing where done on my server where the decimal symbol is a point and thousand separator.
Now I moved my application on my client's server but there the decimal symbol is a coma and the thousand separator is a point.
The problem being that my users are entering the data with a point as decimal OR a coma as a decimal. When using the point as a decimal symbol I am having what's shown below where the user enters 37.756 but when the data is retrieved from the db it's showing 37756 !
Data are inserted with a stored procedure is there a way to do something ?
Jean-Luc
www.corobori.com -
Can the user change its regional settings?
-
I guess he can.
By the way the application is written in ASP (NOT in .NET)
Jean-Luc
www.corobori.com -
I had the same problem in an application I wrote. At the time I was working for a U.S. company (guess what server settings they used) but with salesmen throughout Europe who had mainly set up their machines with localised configurations (German. French, Italian, Spanish etc.). IMHO, to ask them to change their local settings to US English is not a viable option as this affects everything they do. To switch settings to use one app is a major PITA.
I ended up writing code in the ASP page to catch the use of ',' as the decimal separator and replace it with a '.'. The same applies to the thousands separator, in reverse. I did a scan of the input. It may be possible to use the browser language settings, but this may not be reliable.
Regards
Otto
Best Regards,Otto Schreibke
The future is a foreign country, they do things differently there.
(Stolen from Arthur C Clarke) -
I guess I'll have to do this. What should I do to change for that particular database to consider the decimal symbol as the comma ?
Jean-Luc
www.corobori.com
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply