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