--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...> wrote:

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

Yes, i meat that i set it to ISO8859_1 DE_DE

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

Max