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
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
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With