i have database table represent people , records have people's names in them. of names have accented characters in them. not. non-accented duplicates of accented version.
i need generate report of of potential duplicates finding names same (first, middle, last) except accents else can go through list , verify true duplicates, , different people (i'm assuming have other way of knowing).
for example: jose distinct-last-name , josé distinct-last-name should picked potential duplicates because have same characters, 1 has accented character.
how can type of query written in mysql?
this question: how remove accents in mysql? not same. asking de-accenting strings in-place , poster has second column of data has been de-accented. also, accepted answer question set character set , collation. have set character set , collation.
i trying generate report finds strings in different records same except accents.
i found question interesting.
according article accents in text searches, using "like" condition character collation adjustments solve problem. have not tested solution, if helps you, please come , tell us.
here similar question: accent insensitive search query in mysql, according that, can use like:
where 'josé' 'jose' collate utf8_general_ci 