Accent insensitive search - Mailing list pgsql-general

From Alejandro Javier Pomeraniec
Subject Accent insensitive search
Date
Msg-id 20030701151154.319d1416.apomeraniec@buenosaires.gov.ar
Whole thread Raw
Responses Re: Accent insensitive search
Re: Accent insensitive search
List pgsql-general
Hi ! Does anyone knows how to make accent insensitive searches??

For example

i have this data in a table

--------
Colón
Polo
--------

I need that this query

SELECT * FROM testtable WHERE testfield like '%olo%';

brings both results instead of only showing Polo.

Thanks in advance!


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Cannot create unique index
Next
From: Ian Barwick
Date:
Subject: Re: Accent insensitive search