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 | [EMAIL PROTECTED]
Programador, Administrador, DBA | Centro de Telematica
Universidad Nacional
del Litoral
-----------------------------------------------------------------
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
