Hi all,

I have a field defined with charset ISO8859_1 and collation PT_BR.

There are accented values stored in its records.

Is there a way to get these values without accents and in uppercase?

I have an old UDF library that does what i need.
The function is called COLLATEBR, but i would like to achieve it using
the standard firebird language.

I tried some variations of the command below, always geting "Cannot
transliterate character between charsets".

select cast(a.nome as varchar(100) character set ascii) from cad1 a
where a.numcad1 = 7;

Regards,

Fabiano.