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
