> Aaargh, leave those tables alone!! Just set the collation in the ORDER BY
> clause itself:
>
> ORDER BY SOME_COL COLLATE DE_DE

I prefere to have it in the column, because I want to keep my SQL
independent from specific databases. Applications have to run on MS SQL
Server, Oracle and Firebird.

So I probably to it with the help of a temporary column to drop and add
my original column with the correct collation.

cu Christian