Hi Max,
You're forgetting that it is your column that is set to DE_DE, and you are trying to UPPER a constant value that doesn't have any collation at all. Try

UPDATE TEST_TABLE SET TEXT = UPPER('Gerät' collate DE_DE) WHERE ID = 5

and you may be more satisfied by the result (at least 'select upper('gerät' collate DE_DE) from rdb$database' works for me in Firebird 1.5).

HTH,
Set

-----Original Message-----
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of max.muster666
Sent: 17. april 2008 10:18
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Problems with UPPER()

If I try to use following Statement:

UPDATE TEST_TABLE SET TEXT = UPPER('Gerät') WHERE ID = 5

The Updated cell contains now "GERäT" but it should be "GERÄT".
My table is set by default to ISO8859_1 DE_DE, but i also tried
WIN1250 WIN1250.
I use Firebird 2.1.0.15999

Regards Max