Re: Seaching without accents - Mailing list pgsql-general

Ok, but I know that is an away to do it automatic

Without using the function TO_ASCII

Thanks,

Augusto

-----Original Message-----
From: Marco Lazzeri [mailto:marcomail@noze.it]
Sent: Wednesday, January 28, 2004 11:51 AM
To: Augusto Cesar Castoldi
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Seaching without accents

Il mer, 2004-01-28 alle 13:42, Augusto Cesar Castoldi ha scritto:
> How can I configure postgreSQL to search without acents?

You have to write queries using TO_ASCII function and 'LATIN 1'
characters encoding.

Example:

SELECT * FROM my_table WHERE TO_ASCII(value, 'LATIN 1') =
TO_ASCII('Vàlùé', 'LATIN 1');

Cheers,
--
Marco Lazzeri