That´s the solution!! Thank you very much!

Is there a way to change all varchar fiels in database to es_es collation?

Best regards!

Ivan Prenosil wrote:

>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)
>
>
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>

--
Jorge Andrés Brugger
DASU - Obra Social del Personal de la Universidad Nacional de la Patagonia
Comodoro Rivadavia, Chubut, Argentina
Correo electrónico: jbrugger@...
Website: www.dasu.com.ar