1

I've seen Horde's address book application that delivers matches very nicely for searches that do not have the correct characters. For example if searching for 'Garcon' the entry with 'Garçon' is delivered. Or a search for 'Tugla' does also deliver 'Tuğla'. I wonder if this is own code or can Mysql handle this. If yes, how can this be achieved.

adnc
  • 113
  • 2

1 Answers1

1

Setting the collation to the appropriate setting (in your case, probably uft8_turkish_ci) will affect which characters are considered equal. I'm fairly sure that with that collation Turkish characters will be equal to their equivalents, but I haven't had much experience in testing this fact - just going by what I read on the MySQL manual site.

Niet the Dark Absol
  • 320,036
  • 81
  • 464
  • 592
  • I've checked the collation of the Horde-DB, this is utf8_general_ci. Could you point me to the Mysql documentation where the matches of equivalents is described? – adnc Jan 18 '12 at 19:10
  • Yes, the equivalent characters are handled by the collation-table. Thanks – adnc Jan 18 '12 at 21:27