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:
- Create new database with desired character set.
- 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