title: How to change Mysql collation to Turkish?
body: <p>I have a mysql schema with utf8 charset and  utf8_unicode_ci collation. Problem is when I want to query some Turkish characters Mysql can't determine this character is Turkish or not.</p>
  
  <p>In Turkish there is "İ" which is capital "i" and "I" which is capital "ı".</p>
  
  <pre><code>SELECT name FROM students where name = "testĞÇ"; //returns "testğç" which is true
  SELECT name FROM students where name = "testI"; //Mysql thinks "I" character is capital "i" and returns null
  </code></pre>
  
  <p>my students table data;</p>
  
  <pre><code>testğç
  testı
  </code></pre>
  
  <p><strong>EDIT:</strong> My "name" column's collation is utf8_unicode_ci.</p>
  
  <pre><code>SELECT name FROM students where name = "testI" collate utf8_turkish_ci; //still returns null
  </code></pre>
  
  <p><strong>EDIT 2:</strong> When I change "name" column's collation from utf8_unicode_ci to utf8_turkish_ci, It works well. But this time I need to change all my table column's collation's to  utf8_turkish_ci and I don't know it will cause any loss of data.</p>