Php/MySql array search with ã, š, é, ë, ú, ü, í, ž

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"

开发者_如何学Go

Thank you in advance for your help

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