I have stored a string in the table with the turkish character "İ"
I would like to be able to select/search "I" and also get the results for "İ" and the other way around.
I have tried playing with collation, it seems i have a few choices: utf8_turkish_ci or utf8_general_ci. But they do not make the select return results with both characters if i search any of them.
What is the best way to achieve this?
I use MySql.