0

I have some problem with using Mysql queries (finding cities) with German letters.

If i typed to autocomplete input city name "Burgen" - the result was "Burgen" and "Bürgen". So You can see, Bürgen don't match Burgen.

So i changed database and tables encoding from ut8_general_ci to utf8_bin.

And now, search works fine, but another problem arises:

Now search result is case sensitive, then i type "burgen" i have no results, but when type "Burgen" - result is correct.

My question is: is there a way to setup database to work with lowercase ?

bytecode77
  • 14,163
  • 30
  • 110
  • 141
Marek Brzeziński
  • 325
  • 1
  • 3
  • 13

0 Answers0