From: Cédric Dufour (public) <cdufour-public@cogito-ergo-soft.com>
To: Pedro Igor <pedroigor@aip.com.br>
To: pgsql-sql@postgresql.org
Subject: Re: Accent-insensitive
Date: Fri, 6 Dec 2002 21:33:10 +0100
Message-ID: <007401c29d66$b1374690$3c8addd5@cednetwork.net> (raw)
In-Reply-To: <002401c29d2b$a6e168a0$0b00010a@aip.com.br>
Use the 'to_ascii' function to convert your string to the "no accent" ASCII
equivalent before accomplishing your comparison
SELECT foo FROM table WHERE ( to_ascii(foo) ILIKE to_ascii('caractères
accentués') );
This does not work with all database locale (LATIN1 is OK, but LATIN9 is
not).
I was actually wondering if this is efficient enough or if there is any more
efficient method to accomplish this...
Cédric D.
-----Original Message-----
From: pgsql-sql-owner@postgresql.org
[mailto:pgsql-sql-owner@postgresql.org]On Behalf Of Pedro Igor
Sent: Friday, December 06, 2002 14:31
To: pgsql-sql@postgresql.org
Subject: [SQL] Accent-insensitive
Does have PostgreSQL some option to allow me execute selects
accent-insensitive ?
I can´t find any reference, including the manual ....
Pedro Igor
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: cdufour-public@cogito-ergo-soft.com, pedroigor@aip.com.br
Subject: Re: Accent-insensitive
In-Reply-To: <007401c29d66$b1374690$3c8addd5@cednetwork.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox