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

You can define the default character set for a database, and this will limit
the possible collation orders to a relevant subset that reflects the chosen
character set.
However you do as you have noticed have to specify the collation order
either when a "text" field is created or when it is manipulated.

Regards
Paul Beach
Main Tel (UK):+44 (0) 1844 354465
Mobile: (UK): +44 (0) 7764 188603
http://www.ibphoenix.com