Matching accented names

[tony h]

Hi, I am hoping someone has got a good answer to this.

I have a database of names and need to provide a name matching process
that ignores accents.

Thus the following matches can be made : œ with oe, ß with ss, àáâä
with a, ç with c, èéê with e, ö with oe. The accents come from central
european languages - I do not need to match with Greek, arabic, chinese
etc.

So that a search entry of any of : Muller, Mueller and Müller would
bring back all three names.

Any help or guidence or warning of pitfalls is greatly appreciated

 

[najmo ahmed]

Hi, I am hoping someone has got a good answer to this.

I have a database of names and need to provide a name matching process
that ignores accents.

Thus the following matches can be made : o with oe, ß with ss, àáâä
with a, ç with c, èéê with e, ö with oe. The accents come from central
european languages - I do not need to match with Greek, arabic, chinese
etc.

So that a search entry of any of : Muller, Mueller and Müller would
bring back all three names.

Any help or guidence or warning of pitfalls is greatly appreciated

 

[najmo ahmed]

Hi, I am hoping someone has got a good answer to this.

I have a database of names and need to provide a name matching process
that ignores accents.

Thus the following matches can be made : o with oe, ß with ss, àáâä
with a, ç with c, èéê with e, ö with oe. The accents come from central
european languages - I do not need to match with Greek, arabic, chinese
etc.

So that a search entry of any of : Muller, Mueller and Müller would
bring back all three names.

Any help or guidence or warning of pitfalls is greatly appreciated

 

[najmo ahmed]

Hi, I am hoping someone has got a good answer to this.

I have a database of names and need to provide a name matching process
that ignores accents.

Thus the following matches can be made : o with oe, ß with ss, àáâä
with a, ç with c, èéê with e, ö with oe. The accents come from central
european languages - I do not need to match with Greek, arabic, chinese
etc.

So that a search entry of any of : Muller, Mueller and Müller would
bring back all three names.

Any help or guidence or warning of pitfalls is greatly appreciated

 

[jallal]

ZJNROJETOPI