C# is sending wrong parameters to mysql

Question

I am sending parameters from c# to the mysql database. Problem is that I have decimal value in c# ( for example : 45.335 ) but when I am sending it to the mysql it keeps sending it in this format ( 45,335 ) What am I doing wrong?

    MySqlConnection con = null;
    MySqlCommand cmd = null;


    con = new MySqlConnection("server=localhost;database=data;uid=root;pwd=*****");
    con.Open();
    cmd = new MySqlCommand("insert into data values (null, ?ParName , ?Parname2);", con);
    cmd.Parameters.AddWithValue("?ParName", OSGconv.deciLat);
    cmd.Parameters.AddWithValue("?Parname2", OSGconv.deciLon);
    cmd.ExecuteNonQuery();

    con.Close();
    }

Dave · Accepted Answer · 2012-05-10 16:03:52Z

2

It's almost certainly a localisation issue; in the UK we use a full stop as a decimal point, but on the continent, a comma is used instead. Check the country settings for your app and database.

answered May 10, 2012 at 16:03

Dave

3,6311 gold badge24 silver badges25 bronze badges

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

2 Comments

user123_456 Over a year ago

I have tried it and I can see that C# is sending value as 5.3 and when it goes into query it gets formated to 5,3 and in my table I only see 5. Can you show me on my example what to do

Stephen Gilboy Over a year ago

what is the data type on that column?

Collectives™ on Stack Overflow

C# is sending wrong parameters to mysql

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related