Re: locale and spanish acute

On Lun 17 Sep 2001 04:31, Tony Grant wrote:
> 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.

But I want it to work with más too. For that I would need to change that
query for this one:

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

Right?

Saludos... :-)

--
Porqué usar una base de datos relacional cualquiera,
si podés usar PostgreSQL?
-----------------------------------------------------------------
Martín Marqués | mmarques(at)unl(dot)edu(dot)ar
Programador, Administrador, DBA | Centro de Telematica
Universidad Nacional
del Litoral
-----------------------------------------------------------------