In some cases, for better character matching and sorting (eg. for umlauts, accented letters, letter variants etc) I'd suggest using utf8_unicode_ci collation.
utf8_unicode_ci
In some cases, for better character matching and sorting (eg. for umlauts, accented letters, letter variants etc) I'd suggest using
utf8_unicode_cicollation.