Solved

How to do a MS Access accent insensitive Query?

Posted on 2003-12-08
5
892 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
What is the normal amount of queries 5 89
use of cookies and regulations 1 106
Fixed div within Bootstrap carousel item 11 63
Facebook React and SyntheticEvents 6 82
This article covers the basics of the Sass, which is a CSS extension language. You will learn about variables, mixins, and nesting.
SASS allows you to treat your CSS code in a more OOP way. Let's have a look on how you can structure your code in order for it to be easily maintained and reused.
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
The viewer will receive an overview of the basics of CSS showing inline styles. In the head tags set up your style tags: (CODE) Reference the nav tag and set your properties.: (CODE) Set the reference for the UL element and styles for it to ensu…

751 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