Re: [GENERAL] locale and spanish acute

[Tony Grant]

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


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly