Hi, Gábor

I think, you cannot accomplish this with the built-in UPPER function.
You must use an UDF anyway. I've tried the UDF_ANSIUPPER function
(wich
is included in TBUDF udf library) with all typical Hungarian
characters and it worked for me.

Regards



--- In firebird-support@yahoogroups.com, "Gabor Kover" <koverg@v...>
wrote:

> Hi,
>
> How can I setup a field (CHARSET, COLLATION, etc.) to make FB's

UPPER

> function to work with character codes other than the ASCII?
>
> For example: select UPPER(label) from CodeXmlObject_t
> original: A tevékenység bemutatása
> results: A TEVéKENYSéG BEMUTATáSA
> my expectation: A TEVÉKENYSÉG BEMUTATÁSA
>
> I also have tried to create an UDF function, but some of the ISO-

8859-

> 2 characters also fail. (Cannot translate character between

character

> set.)
>
> Thanks in advance,
>
> Gabor