Decimal.Parse and incorrect string format error

Question

I have a simple problem with decimal parsing. The following code works fine on my computer but when I publish the project on the server (VPS, Windows Server 2008 R2 standard edition) I get the error "Input string was in incorrect format." Any ideas what's wrong?

I store that parsed number in the MySQL DB table - the column type is DECIMAL(10, 4)

Source Code:

CultureInfo nonInvariantCulture = new CultureInfo("en-AU"); //or pl-PL
nonInvariantCulture.NumberFormat.NumberDecimalSeparator = ".";
Thread.CurrentThread.CurrentCulture = nonInvariantCulture;
string toConvert = ("3,4589").Replace(",", "."); //it's an example
decimal parsed = decimal.Parse(toConvert);

Are you sure the machine in question has en-AU (or pl_PL) cultures installed? On a fresh install, most machines have only the english subsets installed by default. — nvoigt
– nvoigt, Commented Apr 9, 2013 at 8:41

Martin Liversage · Accepted Answer · 2016-11-29 13:35:15Z

45

If you know that the string representation of the number uses comma as the decimal separator you can parse the value using a custom NumberFormatInfo:

var number = "3,4589";
var numberFormatInfo = new NumberFormatInfo { NumberDecimalSeparator = "," };
var value = Decimal.Parse(number, numberFormatInfo);

You can also use an existing CultureInfo for a culture that you know will work like pl-PL but I think this is easier to understand.

If on the other hand the format of the number is 3.4589 you can simply use CultureInfo.InvariantCulture which you can consider a kind of "default" culture based on en-US:

var number = "3.4589";
var value = Decimal.Parse(number, CultureInfo.InvariantCulture);

edited Nov 29, 2016 at 13:35

answered Apr 9, 2013 at 8:47

Martin Liversage

107k24 gold badges216 silver badges263 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Smaug · Accepted Answer · 2013-04-09 08:55:28Z

6

I guess for a work around the below code will sort it out the problem.

decimal parsed = decimal.Parse(toConvert, CultureInfo.InvariantCulture);

answered Apr 9, 2013 at 8:55

Smaug

2,6835 gold badges31 silver badges45 bronze badges

Comments

V4Vendetta · Accepted Answer · 2013-04-09 08:48:10Z

5

You can build a custom NumberFormatInfo to parse your value

something on these lines

NumberFormatInfo numinf = new NumberFormatInfo();
numinf.NumberDecimalSeparator= ",";    
decimal.Parse("3,4589", numinf);

answered Apr 9, 2013 at 8:48

V4Vendetta

38.5k9 gold badges83 silver badges84 bronze badges

Collectives™ on Stack Overflow

Decimal.Parse and incorrect string format error

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related