--- In firebird-support@yahoogroups.com, Aage Johansen <aagjohan@...> wrote:

>
> adrian_avila_mtz wrote:
> <<
> --- In firebird-support@yahoogroups.com, Michael Ludwig <milu71@> wrote:
> >
> > adrian_avila_mtz schrieb am 28.08.2010 um 18:39 (-0000):
> ...
> > >
> > > Yay. I was expecting something more easy like "ALTER DATABASE SET
> > > DEFAULT CHART SET TO ISO8859_1".
> >
> > That would probably be easy, just change a default setting; but I
> > wouldn't expect it to convert *existing* DDL or data, which I guess
> > is what you want to do.
> >
>
> I did that already restoring the db with the -FIX_FSS_M and FIX_FSS_D options.
>
> >>
>
> It might be interesting to see the effect (if any) if you just change
> the rdb$character_set_name (to e.g. 'ISO8859_1') in the table rdb$database.
> All bets are off - don't test with a production database.
>
> --
> Aage J.
>

I tried it and worked well. thx.