Solved

How to do a MS Access accent insensitive Query?

Posted on 2003-12-08
5
888 Views
Last Modified: 2012-05-04
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
0
Comment
  • 3
  • 2
5 Comments
 
LVL 1

Expert Comment

by:kellysgreen
ID: 9898257
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
 
LVL 1

Expert Comment

by:kellysgreen
ID: 9898265
Oh, and this might be better answered in http://www.experts-exchange.com/Databases/MS_Access/
0
 

Author Comment

by:Yann de Champlain, PMP
ID: 9898575
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
 
LVL 1

Accepted Solution

by:
kellysgreen earned 250 total points
ID: 9898707
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
 

Author Comment

by:Yann de Champlain, PMP
ID: 9904493
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

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
css border raidius issue 7 85
xml attribute DTD attribute differences 3 71
Create associate webpages / websites 3 78
Lines Not Lining Up 2 70
Preface This article introduces an authentication and authorization system for a website.  It is understood by the author and the project contributors that there is no such thing as a "one size fits all" system.  That being said, there is a certa…
It's sometimes a bit tricky to use date functions in Oracle BPEL. I'll explain quickly how you can add N days to the current date. In a BPEL process this can be useful, and you can adapt it to fit your needs. First of all, let's see how to add 1 …
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
HTML5 has deprecated a few of the older ways of showing media as well as offering up a new way to create games and animations. Audio, video, and canvas are just a few of the adjustments made between XHTML and HTML5. As we learned in our last micr…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question