Subject Re: How Can I change the default char set of an existing database?..
Author Aage Johansen
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.