From: | Jorge Godoy <jgodoy(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Accent-insensitive search |
Date: | 2007-07-13 02:54:37 |
Message-ID: | 200707122354.37908.jgodoy@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Monday 09 July 2007 18:33:49 turbovince wrote:
> 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 ?
Check the translate() documentation. It isn't the best thing in the world to
have to use it and code things by yourself, but it works.
--
Jorge Godoy <jgodoy(at)gmail(dot)com>
From | Date | Subject | |
---|---|---|---|
Next Message | Ron Johnson | 2007-07-13 03:00:55 | Re: One Large Table or Multiple DBs? |
Previous Message | Robert Treat | 2007-07-13 02:11:11 | Re: Force SSL / username combination |