--- In firebird-support@yahoogroups.com, "georgethenorge" wrote:

>
> Well then, here are really simple questions:
>
> If you create a database with say ISO8859_1, will the UPPER function
> correctly change æøå to ÆØÅ?
>
> Can you change a database from NONE to say ISO8859_1 after it has
> already been populated? I understand that I would need to update
> some field content myself, but other than that, would it work?
>
> Thanks,
> George

We generally use ISO8859_1 as our character set. Connected to one
database with that character set I tried:

SELECT UPPER('æøå') FROM rdb$database

and it returned 'æøå'.

Adding a bit:

SELECT UPPER('æøå' COLLATE NO_NO) FROM rdb$database

returned 'ÆØÅ'.

I have no experience in changing character set, so others will answer
this part.

Set