Sam Mason wrote on 18.03.2009 18:15:
On Wed, Mar 18, 2009 at 04:29:24PM -0000, cifroes wrote:
I have a DB in utf-8 and postgres 8.3.x.
How can I do an accent insensitive search (like ...) ?

No good idea at the moment; I'd somehow expect to find this sort of
normalization in the functionality provided by the "text search" code.
My reasoning being that searching for a word should find it if you're
being accurate or lazy with your accents.  I've not been able to coax it
into doing anything reliable though.

If you can't find anything better in PG; the translate[1] function would
be my best suggestion.  Performance should be better than using regular

Are you aware of any plans to add accent-insesitive collations to PG?

Would be great if PG offered a similar flexibility here as other databases.


Sent via pgsql-general mailing list (
To make changes to your subscription:

Reply via email to