title: Mysql Character Mapping
body: <p>I would like to map foreign characters, especially Turkish characters, to their Latin-1 equivalent in Mysql.</p>
  
  <p>For example,</p>
  
  <pre><code>Select name FROM users WHERE id = 1
  </code></pre>
  
  <p>Result = Çakır</p>
  
  <p>but I would like to get it as:</p>
  
  <p>Cakir</p>
  
  <p>or</p>
  
  <p>Özel -> Ozel</p>
  
  <p>There are couple of Turkish characters and they all have Latin-1 equivalents. ( <a href="http://webdesign.about.com/od/localization/l/blhtmlcodes-tr.htm" rel="nofollow noreferrer">http://webdesign.about.com/od/localization/l/blhtmlcodes-tr.htm</a> )</p>
  
  <p>How can I do that in Mysql by using SQL query? I am also ok with manual mapping since this query will be run couple of times in a day, so the performance impact is not important at this moment.</p>
  
  <p>Thanks in advance,</p>