How to convert "12,4" to decimal en-Us culture

c# cultureinfo
Anand Kumar picture Anand Kumar · Dec 1, 2011 · Viewed 42.5k times · Source

I have a decimal value ("133,3") stored in string column in the database, in norway culture.

after that user changed the regional setting to english-Us. when I convert "133,3" to decimal using CultureInfo.InvariantCulture, getting invalid value or error.

is there any best way to handle this scenario in C# application?

regards, Anand

Answer

Jon Skeet picture Jon Skeet · Dec 1, 2011

Regardless of the system culture, if you specify CultureInfo.InvariantCulture you won't be able to parse "133,3" as a decimal to 133.3. The same is true for US English.

You could just specify a Norwegian culture when parsing the value (using the overload of decimal.TryParse which takes an IFormatProvider), or (preferrably) change the field in the database to reflect the real data type (a decimal number) instead.

Related questions

How to use localization in C#

I just can't seem to get localization to work. I have a class library. Now I want to create resx files in there, and return some values based on the thread culture. How can I do that?

Read More
Is there a way of setting culture for a whole application? All current threads and new threads?

Is there a way of setting culture for a whole application? All current threads and new threads? We have the name of the culture stored in a database, and when our application starts, we do CultureInfo ci = new CultureInfo(theCultureString); …

Read More
DateTime and CultureInfo

I have this in my code: var date1 = DateTime.ParseExact(date, "dd.MM.yyyy HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture); And when my current cultur is dutch (nl-NL) instead of May 1st I get January 5th. I think the …

Read More