title: PHPExcel - Saving weird Characters to Database
body: <p>I'm using PHPExcel version 1.8.0, 2014-03-02.</p>
  
  <p>In the Excel I have this kind of cells:
  Ahumada nº 301 / Huérfanos</p>
  
  <p>But in the database shows:
  Ahumada nÂº 301 / HuÃ©rfanos</p>
  
  <p>Any one knows how to fix this?</p>
  
  <p>This is my code:</p>
  
  <pre><code>include 'PHPExcel/IOFactory.php';
  $inputFileName = 'data.xlsx'; 
  
  try {
      $objPHPExcel = PHPExcel_IOFactory::load($inputFileName);
  } 
  catch(Exception $e) {
  die('Error loading file "'.pathinfo($inputFileName,PATHINFO_BASENAME).'": '.$e-&gt;getMessage());
  }
  
  $allDataInSheet = $objPHPExcel-&gt;getActiveSheet()-&gt;toArray(null,true,true,true);
  $arrayCount = count($allDataInSheet);
  
  for($i=2;$i&lt;=$arrayCount;$i++){
      $local      =   trim($allDataInSheet[$i]['A']);
      $descripcion=   trim($allDataInSheet[$i]['B']);
      $comuna     =   trim($allDataInSheet[$i]['C']);
      $region     =   trim($allDataInSheet[$i]['D']);
      $insertTable= "INSERT INTO sucursales (Numero, Direccion, Comuna, Region, ID_Cliente) VALUES('".$local."', '".$descripcion."','".$comuna."', '".$region."', '".$_POST['select_cliente2']."');";
      mysqli_query($con,$insertTable);
  }
  </code></pre>
  
  <p>Thanks! </p>