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-ow...@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