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
