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
> expressions.
>
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.
Thomas