Subject Re: [firebird-support] Convert large database from UNICODE_FSS to UTF8
Author Milan Babuskov
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???

Here's how I do it:

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

fbcopy s database.fdb newdb.fdb


Milan Babuskov

The easiest way to import XML, CSV
and textual files into Firebird: