Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

How to do a MS Access accent insensitive Query?

Posted on 2003-12-08
5
Medium Priority
?
898 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
Question by:Yann de Champlain
  • 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
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 750 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
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: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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

This article covers the basics of the Sass, which is a CSS extension language. You will learn about variables, mixins, and nesting.
Have you tried to learn about Unicode, UTF-8, and multibyte text encoding and all the articles are just too "academic" or too technical? This article aims to make the whole topic easy for just about anyone to understand.
Viewers will learn about if statements in Java and their use The if statement: The condition required to create an if statement: Variations of if statements: An example using if statements:
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
Suggested Courses

927 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