6

Hi everybody
If someone search for term "zali se mami" in mySql database, what is the best way to make all possible replacements with appropriate signs (for example e => ë, e => é, a => ã, u => ü, u => ú...) so he/she could get all possible results like:
"žali se mami"
"žali se màmi"
"žàli se mami"
"žàli së mami"

Thank you in advance for your help

Goldie
  • 1,570
  • 5
  • 21
  • 33

1 Answers1

7

Use the utf8_general_ci collation on the column. You can read more about the effects of the collation at these two pages in the MySQL manual:

Unicode Character Sets and Examples of the Effect of Collation

Emil Vikström
  • 90,431
  • 16
  • 141
  • 175