Leandro Fanzone <leandro(at)hasar(dot)com> writes:
> I have a table with a text field:
>
[...]
>
> SELECT myfield FROM mytable
> WHERE TRANSLATE(LOWER(myfield), '[accented vowels collection]', '[respetive
> non-accented vowels]')
I faced the same problem and, equivalente to your approach, I used a
combination of to_ascii and upper/lower:
test=# select to_ascii('áéíóúñ');
to_ascii
----------
aeioun
(1 row)
create or replace function to_uascii( text ) as '
select upper(to_ascii($1)) as result
' language 'sql';
I'm wondering whatever this approach works for multibyte encodings
(UTF-8 and such).
Regards,
Manuel.