title: define similar characters in mysql
body: <p>in mysql the following query will return 1</p>
  
  <pre><code>select "Khur Ramābād"="Khur Ramabad"
  </code></pre>
  
  <p>so there is no difference between a and ā in mysql. but ascii code of a=97 and ascii code of ā=196.</p>
  
  <p>is it possible to define same thing for other languages too?
  for example in Persian "ی" and "ي" are same characters with different character codes and some keyboard layouts use "ی" and some other use "ي".</p>
  
  <p>I know I can control it on my application side and replace all ي with ی in there but this doesn't works for all characters. for example "آ" and ا are same but they can't be replaced by each other.</p>
  
  <p>my problem isn't character set. I already using utf8.
  as I said in latin text if you search for "Khur Ramabad" and your field contains "Khur Ramābād" mysql will return the result but in Persian if you have "نارنجی" and search for "نارنجي" it will not return any thing because 'ی' and 'ي' have to different character codes.</p>
  
  <p>my problem isn't character set. I already using utf8.
  as I said in latin text if you search for "Khur Ramabad" and your field contains "Khur Ramābād" mysql will return the result but in Persian if you have "نارنجی" and search for "نارنجي" it will not return any thing because 'ی' and 'ي' have two different character codes.</p>