>>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?
>
>
> Yes. But the mappings will not be right for Norwegian unless you specify
> the NO_NO collation. The lower-to-upper case mappings vary from one locale
> set to another.
>
> You can't (currently) specify a default collation for a database.

Well, you can for a particular character set, when updating the
RDB$DEFAULT_COLLATE_NAME in RDB$CHARACTER_SET_NAME, but this change will
be lost after a backup/restore cycle.


Regards,
Thomas