Re: accent = no accent

From: Tony Grant <tony(at)tgds(dot)net>
To: jose antonio leo <jaleo8(at)storelandia(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: accent = no accent
Date: 2003-02-17 22:55:56
Message-ID: 1045522555.1602.59.camel@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Justin Clift 2003-02-17 22:57:47 Re: shmget problem with Win NT services
Previous Message Patrick Nelson 2003-02-17 22:51:36 Re: RE in where [SOLVED]