> 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