How do I set the correct decimal separator in IIS 6.0?

3
votes

I hope you can help me here... I have a conflict with the decimal separator on my host's dedicated server. The DB (SQL SERVER 2005) uses dot as decimal separator. As a fact, if you query it directly using SQL Server Management you would get dots. However, when the application (.NET C# MVC 2) is running it uses comma instead of dot. I think it's a problem on the server because here in the tests server it doesn't happen.

I've been reading it might be related to regional and time zone configuration but I've already tried setting the server's time zone and regional zone to the U.S. and it still doesn't work.

The main problem for this that I have is because all views which use jquery are not working correctly, and the main issue is because many decimal numbers are set as required fields. Reprogramming it all is an option but I expect to find the way to set everything up correctly due to the size of the app.

Any help will be VERY apprecciated.

Thanks in advance,

Regards.

1
asp.net-mvcasp.net-mvc-2iis-6decimaldecimal-point
I really think it is a regional configuration issue. What OS are you using? How did you change the regional settings? – GôTô
The server uses Windows Server 2003. I did it through Control Panel --> Regional and Language Settings. – met.lord

1 Answers

2
votes

Regional settings are user specific. This means changing them in control panel results in changing them for the current user. But your application does not use the current user, so you need to run regedit to modify the registry (or use a script).

You need to update the regional settings of the profile running your application.

The key for decimal separator is HKEY_USERS\SID\Control Panel\International\iCurrDigits where SID is the unique identifier of the user.

With this link you can find the SID of the related user.