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.

In Turkish there is "İ" which is capital "i" and "I" which is capital "ı".

```
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

```

my students table data;

```
testğç
testı

```

**EDIT:** My "name" column's collation is utf8\_unicode\_ci.

```
SELECT name FROM students where name = "testI" collate utf8_turkish_ci; //still returns null

```

**EDIT 2:** 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.