At 04:52 PM 19/09/2003 +0200, you wrote:

>Hi,
>
>I have to alter a column from
>
>varchar(n) character set ISO8859_1
>
>to
>
>varchar(n) character set ISO8859_1 collate DE_DE
>
>because it's not directly supported with SQL, I tried to manipulate the
>RDB$... tables. I changed in RDB$RELATION_FIELDS the column
>RDB$COLLATION_ID. That didn't have any effect on the order command.

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

ORDER BY SOME_COL COLLATE DE_DE

heLen