How to convert a large database from UNICODE_FSS to UTF8

majstor wrote:

I have large Firebird database about 20GB is database file. I need to convert that database from UNICODE_FSS to UTF8! Is there any solution (step by step if it is possible) how to convert this database?

Dimitry Sibiryakov answers:

1. Create new database with desired character set.
2. Use FBCopy or IBDataPump to copy data from old database to new one.

Milan Babuskov answers:

Here's how I do it:

isql -x database.fdb | sed "s/UNICODE_FSS/UTF-8/" > new.sql
isql
SQL> create database 'newdb.fdb' default character set UTF-8;
SQL> input new.sql;
SQL> exit;

fbcopy s database.fdb newdb.fdb