At 06:18 PM 17/04/2008, you wrote:

>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,

A table isn't set by default to any collation. Neither (at present) can a database be set to a default collation. The default collation is the binary one.

A column or a domain may be given a collation - is that what you meant?

i.e. alter table test_table
alter column "TEXT" type varchar(n) <-- same as before
character set ISO8859_1
collate DE_DE;

./heLen