Subject Search ignoring special characters (accents etc)
Author Werner F. Bruhin
I would like to search in a column ignoring any special characters such
as accents, i.e. éüä etc.

What is the best way of going about this?

My database is using UTF8 character set for the columns I want to search.

Appreciate any hints, documentation links ....