Drupal insert query with uploaded CSV file array
  0 =&gt; 
    array
      'id' =&gt; float 1110
      'description' =&gt; string 'Culture de céréales (à l'exception du riz), de légumineuses et de graines oléagineuses' (length=86)
      'field2' =&gt; float 11
      'field3' =&gt; float 26.631
  1 =&gt; 
    array
      'id' =&gt; float 1120
      'description' =&gt; string 'Culture du riz' (length=14)
      'field2' =&gt; float 11
      'field3' =&gt; float 7.556


With this array what is the correct process for the string "description" to avoid SQL error when data is added with db_insert ?

I use this code for multiple insert :

$query = db_insert('table')-&gt;fields(array('id', 'description', 'field2', 'field3'));

foreach ($sql_query as $record) {
     $query-&gt;values($record);
}

$query-&gt;execute();

// $sql_query is the array described above.
The data come form a file where string were not convert to utf8 at the opening thus the Drupal 7 parsing function for database query couldn't convert string to avoid SQL error.

Sorry but I didn't think that the problem could be as much upstream...