Helmut,

> 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
http://www.upscene.com