searching without accents

[magazine]

Hi.

We're doing an application where the user can do a search. That search retrieves the information from the DB.

The DB has info with words like: 'cão' 'atrás' 'avião'

When the user do a search with the same words but without accents ('cao' 'atras' 'aviao') it doesn't recognized the info.
How can we solve this without having to write all the words without accents in the BD?

Thank you.

 

[LonnieJohnson]

Not sure. I'd like to know myself.

I wrote a program that actually converts the accent letters to ones with no accent. If no help comes, maybe you can tweek it for your needs.



ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

Contact me at ==>lonniejohnson@prodev.us

May God bless you beyond your imagination!!!