Subject | Re: [firebird-support] Database default collation |
---|---|
Author | Fabiano Bonin |
Post date | 2006-11-16T00:22:52Z |
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.
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]