title: Troubles extracting `latin1_swedish_ci` database rows
body: <p>I have a <code>Php</code>script that should extract <code>latin1_swedish_ci</code> encoded Data from <code>Mysql</code> database, the extracted data is then encoded with <code>json_encode</code> method, everything works fine unless the extracted rows contains special characters like <code>é è .....</code>, in that case i get no results, and and the HTML status code is <code>200</code></p>
  
  <p><strong>That is my function</strong></p>
  
  <pre><code>public function categorie()
      {   
          // Cross validation if the request method is GET else it will return "Not Acceptable" status
          if($this-&gt;get_request_method() != "GET"){
              $this-&gt;response('',406);
          }
          $sql = mysql_query("SELECT * FROM categorie", $this-&gt;db);
          if(mysql_num_rows($sql) &gt; 0)
          {
              $result = array();
              while($rlt = mysql_fetch_array($sql,MYSQL_ASSOC)){
                  $result[] = $rlt;
              }
              // If success everythig is good send header as "OK" and return list of users in JSON format
              $this-&gt;response($this-&gt;json($result), 200);
          }
          $this-&gt;response('',204);    // If no records "No Content" status
      }
  
      private function json($data){
          if(is_array($data)){
              return json_encode($data);
          }
      }       
  </code></pre>