I tried the _iso8859_1 in front of the string, but the øæå was just a
simple example. I need to have a field there that will be converted
to uppercase.

But this is the important question: If I create a database with say
ISO8859_1, then will UPPER work with Euro characters?





--- In firebird-support@yahoogroups.com, Pavel Menshchikov
<developer@l...> wrote:

>
> Hello SET,
>
> SET> We generally use ISO8859_1 as our character set. Connected to

one

> SET> database with that character set I tried:
>
> SET> SELECT UPPER('æøå') FROM rdb$database
>
> SET> and it returned 'æøå'.
>
> Because that's just a string for FB.
>
>
> SET> Adding a bit:
>
> SET> SELECT UPPER('æøå' COLLATE NO_NO) FROM

rdb$database

>
> SET> returned 'ÆØÅ'.
>
> SET> I have no experience in changing character set, so others will

answer

> SET> this part.
>
> You may try
>
> SELECT UPPER(_iso8859_1 'your_lowered_str' COLLATE NO_NO) FROM

rdb$database

>
> to let FB know, which character set and collation you want with this
> particular string.
>
>
>
> --
> Best regards,
> Pavel Menshchikov
> http://www.ls-software.com
>