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.

The only way is to extract the DDL, change the characterset and
re-create the database.

Martijn Tonies
Database Workbench - development tool for Firebird and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com