> How about modifyin RDB$FIELDS table to change collation order for the
> fields?
>
> Such As :
>
> UPDATE RDB$FIELDS SET RDB$COLLATION_ID = 1
> WHERE
> (RDB$SYSTEMFLAG = 0) AND
> ((RDB$FILELDTYPE = 14) OR (RDB$FILELDTYPE = 37))
>
> Will this work? Or is it OK to use such statement?

Also look at RDB$RELATION_FIELDS table.

Ivan
http://www.volny.cz/iprenosil/interbase