Re: Full text index without accents

Ya the function name norm_text_latin() was probably misleading, it takes
latin1-ish characters *encoded in UTF8* and brings them to ascii.

Definitely, the following would be much simpler:
SELECT to_ascii('ÀÁÂÃÄÅÒÓÔÕÖ', 'UTF8')

As of 8.3, you have to do some magic with to_ascii() and utf8 characters

SELECT to_ascii(convert_to_latin('ÀÁÂÃÄÅÒÓÔÕÖ'), 'LATIN1')

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Tom Lane
Sent: July 25, 2008 10:42 AM
To: Alvaro Herrera
Cc: Jonathan Bond-Caron; 'Fco. Mario Barcala Rodríguez';
pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Full text index without accents

Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> Hmm, why not simply use to_ascii() ?

The big problem with to_ascii is its inadequate set of supported
encodings. Somebody *really* needs to give it some love on that
front.

regards, tom lane