title: load data local infile with decimal values
body: <p>I made a importer for the csv files for the customer and the problem which I have is that I get truncated values for decimal values in the file, example:</p>
  
  <pre><code>in .csv file price is 12,23
  and in database it is saved as 12.
  </code></pre>
  
  <p>I checked the fields, they are set to decimal(10,2) so this shouldnt be usual. My code for loading file is:</p>
  
  <pre><code>LOAD DATA LOCAL INFILE "U:/v7/root/file/docimport/3/87/article.csv" 
  INTO TABLE im_artikel 
  CHARACTER SET latin1 FIELDS TERMINATED BY ";" IGNORE 1 LINES 
  (article,price,grossprice);
  show WARNINGS;
  </code></pre>
  
  <p>And I get an error:</p>
  
  <pre><code>1265 Data truncated for column 'price' at row 1
  1265 Data truncated for column 'grossprice' at row 1
  </code></pre>
  
  <p>.Csv file looks like this:</p>
  
  <pre><code>Shoes;40,00;21,46
  </code></pre>
  
  <p>I could change all the fields to varchar than I dont have problems, but I think this is not the solution. </p>