Accent insensitive search

From: Alejandro Javier Pomeraniec <apomeraniec(at)buenosaires(dot)gov(dot)ar>
To: pgsql-general(at)postgresql(dot)org
Subject: Accent insensitive search
Date: 2003-07-01 15:11:54
Message-ID: 20030701151154.319d1416.apomeraniec@buenosaires.gov.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2003-07-01 16:09:58 Re: updating data but the constraint is set "immediate"
Previous Message Tom Lane 2003-07-01 14:29:31 Re: Cannot create unique index