How to do a MS Access accent insensitive Query?

How to do a MS Access accent insensitive Query?

That's the question... ;-)

I need to provide english user the ability to find name containing accents without entering them.

Thanks
Yann de ChamplainAssociateAsked:
Who is Participating?
 
kellysgreenCommented:
Hmm... a little digging and I found the SOUNDEX function.  It's not perfect, but seems to be the best method... It appears you can use the DIFFERENCE function w/ a threshold level to determine sameness between two values...

Resources:
http://www.dhs.cahwnet.gov/aids/HIVReporting/SOUNDEX/SOUNDEX.htm

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_setu-sus_3o6w.asp

http://databases.about.com/library/weekly/aa042901a.htm



0
 
kellysgreenCommented:
case insensitive and differing character sets are two different issues altogether.

So you are looking to be able to have a search for "yelle"  return "yellé" ??  I'm not sure you can do that -- the ASCII values of  an e and an é are pretty dissimilar.
0
 
kellysgreenCommented:
Oh, and this might be better answered in http://www.experts-exchange.com/Databases/MS_Access/
0
 
Yann de ChamplainAssociateAuthor Commented:
Yes I amlooking to be able to have a search for "yelle"  return "yellé".

It is possible in MS SQL Server, Oracle....
But I nee to do it in Access.
 I do not want to migrate the bd becasue this app will be rewrited to access from Active Directory.
0
 
Yann de ChamplainAssociateAuthor Commented:
Thanks for the effort.

I cose the subject.  After I've seen your documentation, I see that I should wait to be able to migrate to AD.
I give you the points anyway.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.