0

I have search query that do the search by specific words, and sometimes there is a collision because some Serbian and English words are spelled similar. For example word cilim and ćilim. When search is done for this two words I always get result for the word cilim. It seems that MySQL reads letters c and ć as same one. DB is set to utf8_general_ci and in database config file I got this part $db['default']['dbcollat'] = 'utf8_general_ci';. How can I make MySQL search by Serbian characters?

jmadsen
  • 3,635
  • 2
  • 33
  • 49
Sasha
  • 8,521
  • 23
  • 91
  • 174
  • 1
    is your php<->mysql connection in utf-8 as well? if it's not, the chars may be utf in php, but they'll get mangled on the wire. – Marc B Mar 27 '13 at 21:07
  • Try this: http://stackoverflow.com/a/501151/1385783 – Danny Mar 27 '13 at 21:15

0 Answers0