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