Subject Re: [firebird-support] How to eliminate accents
Author Dean Harding
Fabiano Bonin wrote:
> 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?

That's not something I would want Firebird to be able to do. An
character with an accent to one person is a totally different character
to another. For example, ask a Swede whether you should convert "å" to
"a" during your "remove accents" step.

If you have a UDF that does what you want, I think you should just stick
with that...

Dean.