Subject Re: [firebird-support] change of character set
Author Thomas Steinmaurer

> I created a Database with a wrong character set and now want to change
> it.
> The problem is, that there is a lot of data in the database, I do not
> want to lose.
> Is there a way to change the default character set of a database
> without creating it new? Possibly with backup and restore?
> If not, I have to create a new database and make a data transfer from
> the old to the new database. If possible, I would avoid this.

I once had a system table update script for changing from NONE to
WIN1252. This and backup/restore cyclyes worked a few years ago.

Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions