Gossamer Forum
Home : General : Databases and SQL :

Accent insensitive search in DB fields

Quote Reply
Accent insensitive search in DB fields
I have built a small searchable employee directory in ColdFusion for my organization. I've come across a little snag in the search function.

Does anyone know how to do an accent INsensitive search? Is there a function in ColdFusion or in SQL to do this?

My users need to be able to search for something like "André" and get both "André" AND "Andre" in the results (and vice versa).

Note: This is not a full text search and I do not use Verity for this application.

Thanks.
Quote Reply
Re: [Crolguvar] Accent insensitive search in DB fields In reply to
Hi,

What database are you using? I believe this has to do with setting the proper character set..

Cheers,

Alex
--
Gossamer Threads Inc.
Quote Reply
Re: [Alex] Accent insensitive search in DB fields In reply to
At the moment I am using MS-Access since the directory is fairly small. We may eventually upsize to SQL Server.