Strange behavior on presentation of dates and decimals

Question

User1340963991 posted

LS,

I have the following configuration:

DB Server with en-US locale
WebServer with en-US locale
Client with nl-NL locale

When a page is displayed on my client the dates and decimals are displayed in en-US culture and not in nl-NL, ie 19.50 instead of 19,50 and 9/25/2009 instead of 25/9/2009.

When I run the webapp from Visual Studio on my client machine connecting to the same DB server, the dates and decimals are displayed correctly in nl-NL culture.

Can someone explain this behavior?

Thanks

Answer 1

User2130758966 posted

I have been having some problems in this area and I noticed this attribute yesterday:

<globalization enableClientBasedCulture="true|false" />

• http://msdn.microsoft.com/en-us/library/hy4kkhe0.aspx

The docs say its not in use but I dont know if it has any affect on this kind of thing?

Answer 2

User1340963991 posted

I solved the problem by adding the following line to web.config:

<globalization culture="auto" uiCulture="auto" />

 

Then I added the Dutch language to IE and guess what... it works.

Answer 3

User2130758966 posted

I think it defaults to auto for both of those if you didnt set anything in your web.config.