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. -- Sam http://samason.me.uk/ [1] http://www.postgresql.org/docs/current/static/functions-string.html - Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
