intellix Posted December 12, 2010 Share Posted December 12, 2010 Hey guys, creating an autocomplete function for something and I'm hit with problems of case sensitivity... At work we have a language file for different languages like: English, Swedish, Russian, Turkish, Greek; etc and I was under the impression that to support all of these languages and for future compatibility, all my databases needed to be UTF8 like the language file at work. So I'm using UTF8-BIN Now it comes to this, I read the Mysql document and BIN is a case sensitive collation? It looks like I have to convert it on the fly to a case-insensitive collation but I don't see the point in that? Surely it should just be an insensitive collation from the start? What would you recommend? How does this work with other character sets? I'm looking here at: utf8_bin utf8_general_ci After reading a little I guess what I want is utf8_general_ci as I want a bit of flexibility for string comparisons. Is there a difference in performance at all? Thanks, Dom Quote Link to comment https://forums.phpfreaks.com/topic/221392-collation-and-case-sensitivity/ Share on other sites More sharing options...
fenway Posted December 12, 2010 Share Posted December 12, 2010 In general, use case-insensitive collations -- no performance hit. Quote Link to comment https://forums.phpfreaks.com/topic/221392-collation-and-case-sensitivity/#findComment-1146320 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.