Subject Re: [firebird-support] Database default collation
Author Fabiano Bonin
Can i change the default collation of a charset this way?

update rdb$character_sets a set
a.rdb$default_collate_name = 'PT_BR'
where
a.rdb$character_set_name = 'ISO8859_1';

What are the implications of such command? I see new tables are created
using this collation. Is there something else happening?

Regards,

Fabiano.

On 11/14/06, Helen Borrie <helebor@...> wrote:
>
> At 03:07 AM 15/11/2006, Jorge Andrés Brugger wrote:
> >Is there a way to set database-wide default collation set? I can define
> >charset at creation time, but not collation ... (Using FB 2.0)
>
> No; it is defined at table level and can be
> defined/overridden at column level.
>
> ./hb
>
>
>


[Non-text portions of this message have been removed]