In mysql when a user tries to add a char entity with containing uppercase of turkish I it gives an error. I searched for the cause and I learned that turkish I is mixed with lower turkish ı and i when lowercasing. Is there any way to use lower turkish ı on mysql? My mysql server is utf8_general and collates with utf8_general_ci. Can windows-1254 may help?

CodePudding user response：

To sum up, you should not use upper turkish I in any of your codes. It conficts with what just you said. Windows1254 sure helps with the issue of confliction.