Re: accent = no accent - Mailing list pgsql-general

On Mon, 2003-02-17 at 11:34, jose antonio leo wrote:
> Hi again!!
>
> How can I make selects not accent sensitive?
>
> The select:
> Select * from articul where desc like 'jamon'
> return the sames record that is
> Select * from articul where desc like 'jamon'

Select * from articul where to_ascii(desc) like 'jamon'

Cheers

Tony Grant
--
www.tgds.net Library management software toolkit,
redhat linux on Sony Vaio C1XD,
Dreamweaver MX with Tomcat and PostgreSQL