> Now I'm use ISO8859_1 as charset und for every VarChar-/Char-Field the
> collate DE_DE.
> Then the UPPER()-function works fine with german umlauts.

Yes, but ISO8859_1 doesn't have the Euro sign. If your application is
the only application that uses the database, that will be no problem,
because the Euro sign will get stored as character #128 (which doesn't
have any meaning in ISO 8859-1), but it will also be read as #128 and
if you display that in Windows, it will become the Euro sign again.

When your database is/will be also accessed from a web interface or a
Linux/Max application, you will get trouble. In this case you should
take a deep look at Unicode ...


Best Regards

Stefan


--
Stefan Heymann
www.destructor.de/firebird