title: Incorrect decimal value: for column mysql
body: <p>Soo I have a application that can insert and update data into my MySQL database. Inserting the data works like a charm but when I try to update the data I receive the following exception:</p>
  
  <blockquote>
  <pre><code>Incorrect decimal value: '1,5' for column 'NumberOfHour' at row 1
  </code></pre>
  </blockquote>
  
  <p>This is the code im using for the update:</p>
  
  <pre><code>public void updateRecord(int activityID, string description, int projectID, int customerID, int hourID, int employeeID, int departmentID, int superviserID, string fixedFlex, string employeeType, decimal NumberOfHour, DateTime date, int CallID)
  {
  
          MySqlConnection conn = new MySqlConnection("database=hourregistration;server=193.78.140.90;username=Hour");
  
          conn.Open();
          using (MySqlCommand cmd = new MySqlCommand(string.Format("UPDATE activity SET Description='{0}',ProjectID='{1}',CustomerID='{2}',HourID='{3}',EmployeeID='{4}',DepartmentID='{5}',SuperviserID='{6}',FixedFlex='{7}',EmployeeType='{8}',NumberOfHour='{9}',Date='{10}',CallID='{11}' WHERE ActivityID='{12}';", description, projectID, customerID, hourID, employeeID, departmentID, superviserID, fixedFlex, employeeType, NumberOfHour, date.ToString("yyyy-MM-dd"), CallID, activityID),conn))
          {
              cmd.ExecuteNonQuery();
          }
  }
  </code></pre>
  
  <p>When I update the data without a decimal value (example: 5) its fine but when I try to user a comma (example: 5,1) I receive the exception..</p>
  
  <p>Here is the Create table statement:</p>
  
  <pre><code>CREATE TABLE `activity` (
    `ActivityID` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `Description` varchar(100) DEFAULT NULL,
    `ProjectID` int(10) unsigned NOT NULL,
    `CustomerID` int(10) unsigned DEFAULT NULL,
    `HourID` varchar(1) NOT NULL DEFAULT '4',
    `EmployeeID` int(10) unsigned NOT NULL,
    `DepartmentID` int(10) unsigned DEFAULT NULL,
    `SuperviserID` int(10) unsigned DEFAULT NULL,
    `FixedFlex` varchar(10) DEFAULT NULL,
    `EmployeeType` varchar(45) DEFAULT NULL,
    `NumberOfHour` decimal(10,2) DEFAULT '0.00',
    `Date` date DEFAULT NULL,
    `External` tinyint(1) DEFAULT '0',
    `CallID` int(10) DEFAULT '0',
    PRIMARY KEY (`ActivityID`) USING BTREE
  ) ENGINE=InnoDB AUTO_INCREMENT=54325 DEFAULT CHARSET=latin1 AVG_ROW_LENGTH=20 ROW_FORMAT=FIXED;
  </code></pre>