title: Accented characters and MySQL searching
body: <p>I've searched for a question for hours and I haven't found an answer that was suitable for me, so... Here I come...</p>
  
  <p>I'm Hungarian and we use the following accented characters in our language: áéíóöőúüű (and of course the capital counterparts)
  I want to make a smart search in php where the user is allowed to enter a search word and it finds the result whether it has the accent or not and both in the MySQl table or the search field. So...</p>
  
  <p>My MySQL table is using utf8_hungarian_ci
  I can do the php conversion so that either the user types in 'Bla' or 'blá', it will return 'bla' and we are searching the mySQL database.</p>
  
  <p>But my problem is... My database might have a 'bla fér' or a 'bláter' field entry. But if we search with 'bla' (from PHP) it only return 'bla fer'. How can I convert the field I'M searching to make 'bla fér'-> 'bla fer' and 'bláter' - > 'blater'. So essentially...</p>
  
  <p>I want to get rid of the accented characters and make them into unaccented ones. But of course, only for the sake of searching. Please help! Thank you!</p>
  
  <p>EDIT:</p>
  
  <pre><code>&lt;?php 
  $search = $_GET["search"]; // May contain áéíóöőúüű
  $accented= array("Ö","ö","Ü","ü","ű","Ó","ó","O","o","Ú","ú","Á","á","U","u","É","é","Í","í"," ","+","'","ő", "Ű", "Ő", "ä","Ä","ű","Ű","ő","Ő");
  $nonaccented=array("O","o","U","u","u","O","o","O","o","U","u","A","a","U","u","E","e","I","i","_","_","_","o", "U", "O", "a","A","u","u","o","o");
  $search = str_replace($accented,$nonaccented,$search);
  $query = "SELECT id, name FROM people WHERE name LIKE '%$search%'"; // Database column 'name' may also contain áéíóöőúüű
  ?&gt;
  </code></pre>