|Subject||Re: How Can I change the default char set of an existing database?..|
--- In firstname.lastname@example.org, Aage Johansen <aagjohan@...> wrote:
>I tried it and worked well. thx.
> adrian_avila_mtz wrote:
> --- In email@example.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.