Re: locale and spanish acute

On Mié 12 Sep 2001 21:52, Peter Eisentraut wrote:
> Martín Marqués writes:
> >
> > What does "accent-fold" mean?
>
> Convert all accented characters to some other characters in a way that is
> meaningful to you.

OK, I think I got what you told me.
lets see... I have this query:

select count(*) from tab1 where col1 LIKE '%mas%'

but I would like it to catch rows with "más" also.

The only thing I can think of is makeing a function that applied to col1
would give me col1 but without accents. Say the function is called
no_accents, so:

no_accents(más)=mas

Now, the problem is that I have little idea on making such a function. Is it
very difficult?

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
-----------------------------------------------------------------