Postgres Pro
Downloads
Home   >   mailing lists

Re: locale and spanish acute - Mailing list pgsql-general

From Tony Grant
Subject Re: locale and spanish acute
Date
Msg-id 1000711887.8351.3.camel@tonux
Whole thread Raw
In response to Re: locale and spanish acute  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: locale and spanish acute
List pgsql-general
Tree view 
On Fri, 2001-09-14 at 15:49, Peter Eisentraut wrote:
> Martín Marqués writes:
>
> > select count(*) from tab1 where col1 LIKE '%mas%'
> >
> > but I would like it to catch rows with "más" also.

select count(*) from tab1 where col1 ILIKE to_ascii($1)

works for me.

The variable is passed via .jsp

Cheers

Tony Grant

--
RedHat Linux on Sony Vaio C1XD/S
http://www.animaproductions.com/linux2.html
Macromedia UltraDev with PostgreSQL
http://www.animaproductions.com/ultra.html

pgsql-general by date:

Previous
From: BELLON Michel
Date:
Subject: Re: commercial usage with odbc
Next
From: "Tille, Andreas"
Date:
Subject: Disk performance (Was: How to make a REALLY FAST db server?)