If you change collation by direct updating system tables,
you have to recompute (i.e. set Inactive/Active) your indexes.

Ivan

----- Original Message -----
From: "Jorge Andrés Brugger" <listas@...>
To: <firebird-support@yahoogroups.com>
Sent: Tuesday, May 11, 2004 4:25 PM
Subject: Re: [firebird-support] Re: Case sort order/collation order related?


Peter:

Thanks for your answer. I´ve tried the change with no success ... it´s
posible that if other users are using the database, the change doesn´t
apply, even if I get no errors? (Using IB Expert)
And one more question: how can I change all database varchar fields to
ES_ES collation? (I´ve too much of this ones and all defined as ISO8859_1)