title: Characters "ي" and "ی" and the difference in persian - Mysql
body: <p>I'm working on a UTF-8 Persian website with integrated mysql database. All the content in the website are imported through an admin panel and it's all persian.</p>
  
  <p>As you might know arabic language has the same letters as persian except some.
  The problem is when a person tries to type on a keyboard with arabic layout it writes "ي" as an character and if he tries to type by a keyboard with persian layout it types "ی" as character. </p>
  
  <p>So if a person searches for 'بازی' the mysql won't find 'بازي' as the result.</p>
  
  <p><em>Important Note: 'ی' is not the only character with this property, there are lots of them and they are very similar.</em></p>
  
  <p>How can I fix this issue? </p>
  
  <p><strong>One simple naive solution</strong> seems to be replace all  "ي" with "ی" before importing the data into database, but i'm searching for a better robust solution than this.</p>