Thanks for the replies,

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?

TIA

Cagatay Tengiz


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

> Is there any method to set default collation order for database or must I
> set it everytime I create a char/varchar/blob field?

Currently not.

But you can save lot of work by using DOMAINs. E.g.
create domain u_name varchar(31) character set win1250 colleate pxw_csy;
create table tab(
owner_name u_name,
editor_name u_name,
administrator_name u_name, ...);
instead of
create table tab(
owner_name varchar(31) character set win1250 colleate pxw_csy,
editor_name varchar(31) character set win1250 colleate pxw_csy,
administrator_name varchar(31) character set win1250 colleate pxw_csy,
...);


Alternatively, first create database without specifying collation,
and then alter collation for all fields at once by updating system tables.

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