Accent-insensitive search - Mailing list pgsql-general

From turbovince
Subject Accent-insensitive search
Date
Msg-id 1184016829.689012.314350@r34g2000hsd.googlegroups.com
Whole thread Raw
Responses Re: Accent-insensitive search  (Jorge Godoy <jgodoy@gmail.com>)
Re: Accent-insensitive search  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-general
Hello, I would like to perform some accent-insensitive searches on my
database, which means that a select query with condition, say, WHERE
NAME = 'HELLÔ' would return records where name is 'HELLO' as well.

My data is encoded in Unicode (UTF8) and therefore I cannot use
Postgre's to_ascii() trick to achieve accent-insensitive searches.

Is there any way I could perform such searches with an UTF8 encoding ?

Thank you.


pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Duplicate Unique Key constraint error
Next
From: Benoit Mathieu
Date:
Subject: TOAST, large objects, and ACIDity