Re: Accent insensitive search?

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Accent insensitive search?
Date: 2009-03-18 17:32:21
Message-ID: 49C13025.8000101@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

how about...

select .... where translate(lower(myfield),
'âãäåāăąèééêëēĕėęěìíîïìĩīĭóôõöōŏőùúûüũūŭů',
'aaaaaaaeeeeeeeeeeiiiiiiiiooooooouuuuuuu') = 'stringiwannamatch';

or something like that. I may have miscounted the vowells in the 'to'
string :)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Kellerer 2009-03-18 17:33:16 Re: Accent insensitive search?
Previous Message Thom Brown 2009-03-18 17:24:20 Re: Accent insensitive search?