Accent Marks - Mailing list pgsql-sql

From Jonathan Karlen
Subject Accent Marks
Date
Msg-id 004801bf3f36$f2104680$94b1f4d1@westnet.com
Whole thread Raw
Responses Re: [SQL] Accent Marks
List pgsql-sql
Greetings,
 
I have a a client whom we're building a web application for that contains data in many languages.  What they would like is for queries to be accent insensitive.  In other words, for example in Spanish, if I was to search on the word "ir", I'd get back any results containing either "ir" or the same word with the "i" having an accent mark.  I don't see how this is possible.  Any advice?
 
Jonathan Karlen
**********************************************
Jonathan R. Karlen
Karlen Internet Solutions
jkarlen@karlen.com
www.karlen.com

pgsql-sql by date:

Previous
From: Stoyan Genov
Date:
Subject: Re: [SQL] Howto to force NULL rows at the bottom ?
Next
From: "tjk@tksoft.com"
Date:
Subject: Re: [SQL] Accent Marks