Not case insensitive but accent insensitive :)
And I tried select to_ascii('capo','LATIN1'), to_ascii('çapo','LATIN1') and the results are different....
-----Original Message-----
From: pgsql-general-owner@postgresql.org on behalf of Pedro Doria Meunier
Sent: Wed 3/18/2009 4:46 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Accent insensitive search?
Hi,
use ILIKE
HTH,
Pedro Doria Meunier
GSM: +351961720188
Skype: pdoriam
On Wednesday 18 March 2009 04:29:24 pm cifroes wrote:
> Hi,
>
> I have a DB in utf-8 and postgres 8.3.x.
>
> How can I do an accent insensitive search (like ...) ?
>
>
> TIA