Subject Re: [firebird-support] change of character set
Author Tim
At 08:58 05/06/2006, you wrote:

>I created a Database with a wrong character set and now want to change
>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.
>Kind regards

Use a two - step process :

Recreate the database (an empty database) with the correct character set.

Use a data pump to pump the data across from the old database to the
new database.