Finding a Php / MySql array using ã, š, é, ë, ú, ü, í, ž

Question

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

Thank you in advance for your help.

Answer 1

Use the utf8_general_ci in the column. You can learn more about the effect of sorting on these two pages in the MySQL manual:

Unicode Character Sets and Sorting Effect Examples