Thanks for your support Ivan, I solved my problem as :

First I updated RDB$FIELDS table :
UPDATE RDB$FIELDS SET RDB$COLLATION_ID = 1
WHERE
(RDB$SYSTEM_FLAG = 0) AND
((RDB$FIELD_TYPE = 14) OR (RDB$FIELD_TYPE = 37))

Second I updated RDB$RELATION_FILELDS table :
UPDATE RDB$RELATION_FILELDS SET RDB$COLLATION_ID = 1 WHERE RDB$FIELD_SOURCE
IN
(SELECT RDB$FIELD_NAME FROM RDB$FIELDS WHERE
(RDB$SYSTEM_FLAG = 0) AND ((RDB$FIELD_TYPE = 14) OR (RDB$FIELD_TYPE =
37)))

Third :
I backed up and restored databes to rebuild indexes. And all was fine.

Best Regards

Cagatay Tengiz


-----Original Message-----
From: Ivan Prenosil [mailto:prenosil@...]
Sent: Monday, October 08, 2001 2:09 PM
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] Setting default collation order for entire
database

> 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



To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/


_________________________________________________________
Do You Yahoo!?
Get your free @... address at http://mail.yahoo.com