Re: Seaching without accents

From: Marco Lazzeri <marcomail(at)noze(dot)it>
To: Augusto Cesar Castoldi <castoldi(at)npd(dot)ufsc(dot)br>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Seaching without accents
Date: 2004-01-28 13:51:15
Message-ID: 1075297875.2490.33.camel@macbeth.intranet.noze.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Franco Bruno Borghesi 2004-01-28 13:52:32 Re: Logging all queries (almost there)
Previous Message Augusto Cesar Castoldi 2004-01-28 12:42:39 Seaching without accents